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 are the advantages a stored procedure? : Sql dba

534


How many types of indexes are there in sql?

527


What is the difference between rename and alias?

693


What is embedded sql with example?

531


How do I truncate a word?

511






How does cross join work?

492


What is the difference between microsoft access and sql?

487


Is sql free?

492


What are three advantages to using sql?

539


What is denormalization in a database?

583


explain normalization concept? : Sql dba

574


How do I view a sql trace file?

553


how to use case expression? : Sql dba

541


Why coalesce is used in sql?

461


what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

563