OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Index Entry (Oracle,9i,SunOs)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Index Entry [message #298686]

Thu, 07 February 2008 02:53

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

Hi,
Please correct me my understanding about the size of the index (non unique) entry in bytes for a indexed column whose data type is date (7 bytes)

I have checked this it is showing 19 bytes in index_stat table, 1 byte to store length of date columns i.e.7
7 bytes for storing date columns
2-3 bytes for header information like lock....
8 bytes for row id

Thanks.

Report message to a moderator