How many index keys possible for a table

Answer Posted / saravanan

four index keys is possible per one table.
read only table u havae create more then index per table

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Dependency Injection and provide example?

800


Create and insert into temp table in sql server?

765


What are the types of joins in sql?

750


What is the difference between delete and truncate statements?

740


What are the acid properties?

717






What is transaction server distributed transaction?

712


How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

931


How to generate random numbers with the rand() function in ms sql server?

753


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

1719


Explain few examples of RDBMS?

759


What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

686


Is the primary key column of a table an index in ms sql server?

695


How can we delete a table in sql server?

712


What is extended stored procedures?

712


What happens when transaction log is full?

651