Home » RDBMS Server » Performance Tuning » Index Entry (Oracle,9i,SunOs)
Index Entry [message #298686] Thu, 07 February 2008 02:53 Go to next message
Messages: 240
Registered: June 2005
Location: India
Senior Member
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

Re: Index Entry [message #298775 is a reply to message #298686] Thu, 07 February 2008 11:28 Go to previous message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
More or less, why?

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

Current Time: Fri Aug 18 13:30:35 CDT 2017

Total time taken to generate the page: 0.38112 seconds