adspace


How many index keys possible for a table

Answer Posted / anand k

One table can only one clustered index or primary key and
249 non-clustered index or unique key

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

do you know how to configure db2 side of the application? : Sql server database administration

1125


How can I check that whether automatic statistic update is enabled or not?

1113


Can one drop a column from a table?

1091


You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1215


What is the primary use of the model database?

1151


What is self contained sub query?

1141


Can you index views?

955


what is spatial nonclustered index

1060


Why we use the openxml clause?

1080


How can you append an identity column to a temporary table?

1071


What is a scheduled job or what is a scheduled task?

1040


Explain system functions or built-in functions? What are different types of system functions?

1067


How to enter binary string literals in ms sql server?

1246


What is normalization and what are the advantages of it?

1057


What are the different SQL Server Versions you have worked on?

1080