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's dateware house and what's clustor with practicle example
What is a initialization parameter file in oracle?
How to define a specific record type?
What are a query and state the different types of queries and their uses?
What is a private synonym?
What is difference between cartesian join and cross join?
How to define a variable to match a table column data type?
How to use attributes of the implicit cursor in oracle?
What are the differences between lov and list item?
What are oracle functions?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What is bind variable in oracle 11g?
What is the data pump export utility?
What is the usage of analyze command in oracle?
How to update values on multiple rows in oracle?