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

What are the advantages of pl sql over sql?

732


what are the different index configurations a table can have? : Sql dba

743


Explain the savepoint statement.

811


What is trigger types of trigger?

718


What is compound trigger?

752






What sql database should I use?

786


List out the acid properties and explain?

709


what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

728


How do I upgrade sql?

733


What are database links used for?

748


What are pl/sql packages?

760


Does truncate remove indexes?

719


what are the types of join and explain each? : Sql dba

763


explain access control lists. : Sql dba

714


How does stored procedure reduce network traffic?

730