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

Answer Posted / swapna vamsi

upto 249 unclustered indexes per table

Is This Answer Correct ?    30 Yes 28 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many aggregate functions are available there in sql?

517


Is primary key clustered index?

508


What is posting?

590


What is a trigger in sql?

630


What are the different types of triggers?

575






How many columns should be in an index?

510


Is sql between inclusive?

577


What are the usages of sql?

554


what is a database? : Sql dba

595


What is pragma in pl sql?

585


Does oracle roll back the transaction on an error?

522


what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

653


what are the advantages a stored procedure? : Sql dba

532


Which is faster count (*) or count 1?

525


is it possible to pass an object or table to a procedure as an argument?

551