How many index keys possible for a table

Answer Posted / namz

There can only be one clustered index but multiple non-
clustered index

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a livelock?

549


What is simple indexing method?

569


Who developed sql server?

522


How do you improve the performance of a SQL Azure Database?

115


you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

573






What are the disadvantages of using querystrings to send data from one page to another?

578


Why do we need normalization?

482


What is the importance of concurrency control?

659


How you can get the list of largest tables in a database?

514


Can group by and orderby be used together?

591


How to insert data with null values?

580


How do I find the query plan in sql server?

540


Difference between aggregate functions of sql?

645


What is surrogate key? : sql server analysis services, ssas

685


What is a derived table?

505