• Add a Comment
  • Edit
  • More Actions v
  • Quarantine this Entry

Comments (1)

1 G_Radhika commented Permalink

Hi JR,

 
Maximum index size can be calculated by this formula:
 
[(PAGESIZE -93)/5] -1
 
like for 2k it is [( 2048-93)/5] -1 =[1955/5] -1 =391-1=390
 
if PAGESIZE is 4K it is [(4096-93)/5] -1 =4003/5-1=800-1 =799
 
so for 2k it is 390.
 
create table t1(c1 char(255),c2 char(135) ,primary key(c1,c2)) --> 255+135=390 will be successful where as
create table t1(c1 char(255),c2 char(136) ,primary key(c1,c2)) -->255+136=391 will give error 550
 
Thanks,
Radhika

Add a Comment Add a Comment