Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How index stores and works internally

976208Nov 12 2014 — edited Nov 13 2014

Hi Experts,

For every record of table corresponding entry wil be made in index?

Let us say in a table 500000 records

then in the index also 500000 records will be stored along with row address?If so then index ans table also occupies same amount of stroage?

Thanks.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 11 2014
Added on Nov 12 2014
14 comments
2,762 views