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 meant by magic query
How to fetch the row which has the max value for a column?
What are the ways tablespaces can be managed and how do they differ?
What are the different types of synonyms?
How do you bind variables in oracle?
Explain compound trigger in oracle?
What are advantages of dateset in datastage?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
Does oracle partitioning improve performance?
What are dml statements in oracle?
How can we find out the current date and time in oracle?
What do you mean by redo log file mirroring?
Explain about achiever in sql?
Explain the use of owner option in exp command.
What is the purpose of tables, private synonyms and public synonyms in Oracle?