Interested to Buy Any Domain ? << Click Here >> for more details...
When do u use clustered index and non-clustered index?
- 3 Answers
- 8721 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / chethan nagaraj
Clustered index is faster when there is selecting a range
of values while the non clustering index is useful when
there is a modification(DML),
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
role of sql sever 2005 in database rather than any other database
What are commonly used mssql functions in php?
How can you fetch alternate records from a table?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What happens if null values are involved in datetime operations?
Explain the difference between delete,drop and truncate in SQL Server?
How to rebuild indexes with alter index ... Rebuild?
What is the advantage of sql server?
Explain indexing and what are the advantages of it?
Why we should not use triggers?
What are the key configuration files for sql server reporting services ?
How to drop an existing table with "drop table" statements in ms sql server?
How do I get to sql server configuration manager?
How to get the definition of a trigger back?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
