Home » RDBMS Server » Performance Tuning » Index Entry (Oracle,9i,SunOs)
Index Entry [message #298686] Thu, 07 February 2008 02:53 Go to next message
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.
Re: Index Entry [message #298775 is a reply to message #298686] Thu, 07 February 2008 11:28 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
More or less, why?

Regards
Michel
Previous Topic: Dictionary_cache = 0 ?
Next Topic: Tool/method for detecting changed executions plans
Goto Forum:
  


Current Time: Mon Dec 05 06:53:09 CST 2016

Total time taken to generate the page: 0.09700 seconds