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
- 31454 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
Calculate difference between 2 date / times in oracle sql?
How to create a new oracle data file?
How to create tables for odbc connection testing?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What are group functions in oracle?
IS it possible to built the oracle database without setting the kernal parameters?
How do I limit the number of rows returned by an oracle query after ordering?
How different is ms access and oracle?
What do you mean by merge in oracle and how can we merge two tables?
Explain self joins in oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to create a server parameter file?
Explain integrity constraint?
What is the maximum limit on the number of columns in a table?
What are data pump export and import modes?
