What is an index and types of indexes. How many number of
indexes can be used per table ?
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
What is the use of index in sql?
What is a crud api?
Why do we use set serveroutput on?
What is nvarchar in sql?
What are character functions?
When do we use triggers?
Is there a way to automate sql execution from the command-line, batch job or shell script?
what is cursor. write example of it. What are the attributes of cursor.
Can I join the same table twice?
Why sql query is slow?
What is the difference between join and natural join?
Is sql the best database?
what is uncommittable transactions? : Transact sql
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What will you get by the cursor attribute sql%rowcount?