Interested to Buy Any Domain ? << Click Here >> for more details...
what are indexes..how many types of index's are there and
what are they?
- 7 Answers
- 31487 Views
- Green Info Solutions, TCS, I also Faced
- E-Mail Answers
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 is the use of file param in imp command?
What is backup in Oracle?
How to define an oracle cursor variable?
What are a cluster and non-cluster index?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What's dateware house and what's clustor with practicle example
What is redo log?
What is a read only transaction in oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
List out the components of logical database structure of oracle database.
What are set operators?
Briefly explain what is literal? Give an example where it can be used?
How to do a full database export?
What is a system tablespace?
