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 create a new table by selecting rows from another table?
What is the database name in oracle?
How remove data files before opening a database?
What is a read write transaction in oracle?
why dont we assign not null constraint as table level constraint.
What is an oracle database table?
Can a formula column be obtained through a select statement ?
What are the various constraints used in oracle?
How to drop an index in oracle?
Explain the difference between a procedure and a function? What do you understand by those terms?
How to get execution path reports on query statements?
What is oracle instant client?
What is oracle and what are its different editions?
What is the purpose of save points in oracle database?
Query to retrieve record for a many to many relationship ?