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
What is an oracle transaction?
What is connection pooling in oracle?
how to handle exceptions in post production
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to pass parameters to procedures?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What is a procedure in oracle?
How can I introduce multiple conditions in like operator?
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
How many categories of data types in oracle?
How to invoke the original export import utilities?
What is rowid and rownum in oracle?
Is java required for oracle client?
List the types of joins used in writing subqueries?
how can we store any pdf file in oracle