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

what is not null constraint? : Sql dba

633


How does one use sql*loader to load images, sound clips and documents? : aql loader

769


What is nvarchar in sql?

606


Can a foreign key be null?

695


How do I kill a query in postgresql?

655






What jobs use sql?

613


what are sequences

1209


What is dense_rank?

617


What is a temporal table?

583


How to return an array from java to pl/sql?

686


How many clustered indexes can be created on a table?

682


What is procedure function?

627


Explain the components of sql?

690


How do I write a cron which will run a sql query and mail the results to agroup?

614


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

597