Answer Detail: RE: 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 ?

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Print |

Question: 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 ?

October 10, 2008 01:51:11	#1
niteshaggarwal	Member Since: October 2008 Total Comments: 1
RE: 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 ?
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.