what are indexes..how many types of index's are there and
what are they?
Answer Posted / rudrab123
Answer 1 is not he basic function of Index in Oracle or any
databse.
Generally speaking,attaching index to a column in a table,
information of the location of the different values in the
indexed column is also provided.This address is like the
pointer varible in C,and in SQL it is called ROWID(a
pseudocolumn).Let us see he example ....
SQL>select * from students
where id=123;
Students is a databse table and ID is the column in the
table on which we create the index.
On execution of the above query, at first, the ROWID
corresponding to id=123 in students table is found.From
this rowid, the index value for the row of data which is
pointed to by ROWID is found(in very less time).And so the
row is idenified and the entire row data is displayed.
The above serach process is specifically called "TABLE
ACCESS FULL(USING ROWID)).
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How to load data from external tables to regular tables?
What is an oracle table?
Explain the difference between a procedure and a function? What do you understand by those terms?
Explain the truncate in oracle?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is Segment Advisor in Oracle?
Why do we use bulk collect in oracle?
Difference between hot backup vs. Cold backup?
How to create a new view in oracle?
How to create a new oracle data file?
How to write an inner join with the where clause in oracle?
How to insert a new row into a table in oracle?
What is an oracle wallet?
How to write date and time literals in oracle?