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
- 3706 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 is the max nvarchar size?
Which are sql * plus commands?
What is difference between group by and partition by?
how does a local variable is defined using t-sql? : Transact sql
What is offset and limit in sql?
What is the size of partition table?
Is like operator in sql case sensitive?
Is sql port 1433 encrypted?
what is the difference between nested subquery and correlated subquery?
Explain the uses of database trigger.
What are properties of the transaction?
What is record variable?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
how to use 'mysql' to run sql statements? : Sql dba
What are functions in sql?
