What is an index and types of indexes. How many number of
indexes can be used per table ?

Answer Posted / naresh

index's are used to retrive the data with in the required
time.there are two types of indexes we have

1.bitmap index
2.B-tree index

Is This Answer Correct ?    16 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is partition used in sql?

785


how can we submit a form without a submit button? : Sql dba

720


what is table? : Sql dba

758


What is the difference between microsoft access and sql server?

709


Which is faster joins or subqueries?

713






What is the process of copying data from table a to table b?

799


What is scalar function in sql?

705


Why indexing is needed?

724


What is rank () in sql?

694


What is left join example?

675


What is java sql connection?

688


Explain isolation levels. : Transact sql

741


Are stored procedures faster than dynamic sql?

736


Can we alter stored procedure?

717


What is query execution plan in sql?

771