what are indexes..how many types of index's are there and
what are they?
Answer Posted / rudrab123
An index is a listing of keywords accompanied by the
information of location of the subject.
in a SQL statement, if there is no Where clause then there
is no index.
In Oracle 8i,
there are 4 types of indexes .They are:-
1.B-Tree Index
2.Bitmap Index
3.Unique index
4.Function based index.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How to do clean up if create database failed?
How to commit the current transaction in oracle?
How to create a testing table in oracle?
What is oracle instant client?
what is dynamic SGA and static SGA
Why does Oracle not permit the use of PCTUSED with indexes?
How to invoke the data pump export utility?
What is oracle thin client?
What do you mean by a database transaction & what all tcl statements are available in oracle?
What is a Garbage Collection? and what is full recursive Garbage collection?
Why we use bulk collect in oracle?
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 a initialization parameter file in oracle?
How to create a stored program unit?
What is PL/SQL ?