Interested to Buy Any Domain ? << Click Here >> for more details...
What is an index and types of indexes. How many number of
indexes can be used per table ?
- 12 Answers
- 83883 Views
- Accenture, BirlaSoft, Cognizant, CTS, Symphony, I also Faced
- E-Mail Answers
Answer Posted / guest
Index is a method used for faster retrieval of
records.different types of indexes are
1.primary key index
2.unique index
3.bitmap index
4.hash index
5.function based index
6.B-tree index(default index created) on table.
7.Virtual index(which do not show entry in DBA_segment).
| Is This Answer Correct ? | 128 Yes | 35 No |
Post New Answer View All Answers
Can we join two tables without common column?
How do you optimize a stored procedure in sql?
How do I create a sql script?
What are the disadvantages of not performing database normalization?
how is exception handling handled in mysql? : Sql dba
The select into statement is most often used to create backup copies of tables or for archiving records?
Can triggers stop a dml statement from executing on a table?
How do you write an inner join query?
How long it takes to learn pl sql?
Explain the uses of database trigger.
Can a key be both primary and foreign?
What are the limitations of sql express?
Why we use sql profiler?
What is triggering circuit?
How to find 3rd highest salary of an employee from the employee table in sql?
