What is an index and types of indexes. How many number of
indexes can be used per table ?
- 12 Answers
- 81320 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
how to write date and time literals? : Sql dba
Explain the difference between drop and truncate commands in sql?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
How do I save a stored procedure?
what are the authentication modes in sql server? : Sql dba
Where is sql database stored?
How delete all records from table in sql?
What is an implicit commit?
What is primary and foreign key?
Explain the structure of pl/sql in brief.
what is online transaction processing (oltp)? : Sql dba
How are sql commands classified?
What is crud diagram?
What is difference sql and mysql?
What are the main features of cursor?
