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
What are the advantages of oracle?
What is a cursor and what are the steps need to be taken?
What are the extensions used by oracle reports?
How to run create database statement?
What is define in oracle?
How do I escape a reserved word in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to create a server parameter file?
How remove data files before opening a database?
How to list all user accounts in oracle?
What is oracle instant client?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What is rowid and rownum in oracle?
How to pass a cursor variable to a procedure?
What is a dead lock in oracle?