what are indexes..how many types of index's are there and
what are they?
- 7 Answers
- 16810 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 list all indexes in your schema?
What are the data types in oracle?
What to do if dba lost the system password?
What are ddl statements in oracle?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
Please explain joins in oracle?
What is PL/SQL ?
What is procedure overloading in oracle?
Explain the use of record option in exp command.
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
Explain the difference between sql and oracle?
What is a system tablespace and when it is created?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
Why oracle is used?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
