Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 9877 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / jerry joseph
A table can have 1 clustered index and 249 non-clustered indexes
indexes make sorting efficient
generally clustered index is ideal for the Primary Key
non-clustered indexes are ideal for columns which are used
in sorting (the columns in OrderBy)
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain trigger and its types?
Does hive support indexing?
Is it possible to replicate data from sql server to oracle? : sql server replication
How to create a login account in ms sql server to access the database engine using "create login" statements?
What is key attribute?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
List out some of the requirements to set up a sql server failover cluster?
What are approximate numeric data types in ms sql server?
What are the different types of Indexes available in SQL Server?
Would you store your query in a ssrs report or a database server? State the reason why?
How to connect sql server management studio express to sql server 2005 express?
What is repeatable read?
Write a query to find 5th highest amount paid from the customer table.
What command do we use to rename a database?
How to grant a permission in ms sql server using "grant execute" statements?
