Interested to Buy Any Domain ? << Click Here >> for more details...
what are indexes..how many types of index's are there and
what are they?
- 7 Answers
- 31769 Views
- Green Info Solutions, TCS, I also Faced
- E-Mail Answers
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 view in oracle?
Can we create trigger on materialized view in oracle?
How to invoke the data pump export utility?
What is ASM (Automatic Storage Management) in Oracle?
What is Segment Advisor in Oracle?
 What are the oracle DML commands possible through an update strategy?
How to install oracle odbc drivers?
WHAT IS ecc 6.0
Can we insert data in view oracle?
Hi Can any one tell me what are the API's used in requisition import.
How to use fetch statement in a loop?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Explain a segment?
State all possible different index configurations a table can possibly have?
