How is the data inserted in the Index table when a new row is inserted into the main table on which the index is created ?

Questions by harneet2004us   answers by harneet2004us

Showing Answers 1 - 3 of 3 Answers

niteshaggarwal

  • Oct 20th, 2008
 

The ROWID of that row and the Data value on which that index is created will be inserted in index file. ROWID have row address, which will locate the row at the physical level and thus accessing of that value will be fast.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions