Index column [message #19909] |
Wed, 17 April 2002 23:44 |
Dhinakar
Messages: 1 Registered: April 2002
|
Junior Member |
|
|
Dear friends,
How oracle Internally fetches the rows based on the 'where' clause in the select statement if the column in the 'where' clause is a index based column
Eg., assume that if we are creating a index for a employee number in a employee table which contains 1000 values.In the select statement if we want to retrieve the value based on the employee number,then how oracle internally searches for that particular value.Whether the sorted column value will be stored along with the rowids and the index value or the index tablespace will hold only the corresponding rowids based on the sorted column value along with the index value.
Can anyone explain in elaborate.
Bye
dhina
|
|
|
|