Interested to Buy Any Domain ? << Click Here >> for more details...
Describe the Index, Types of index, At what situation we
have used? Which one s better than others?
- 1 Answers
- 3629 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / oraclem
Index is a DB object that makes data retrieval faster.Index created on column and that column is called index key.
Types of index:
1)BTREE Index
2)BITMAP index
Purpose of creating INDEX: Oracle will take more time to locate the record,to improve the performance of the quesry we have to create the Index.
IF we do not mention the type of index,by default oracle will take BTREE as default Index.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the different types of triggers?
What is parameter substitution in sql?
Why do we use joins?
Which is better join or inner query?
How many types of functions are there 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 ?
What is difference between my sql and sql?
What are the two types of cursors in pl sql?
what are date and time data types in mysql? : Sql dba
what is 'mysqlshow'? : Sql dba
What is a join query?
What is dml with example?
What is replication id?
How to change the order of columns in Oracle SQL Plus ?
Do prepared statements prevent sql injection?
