WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX
Answer Posted / jabamit
CLUSTER INDEX BCZ THAT WORK PHYSICALLY(MEANS ALREADY IN DEC
OR ASC ORDER) BUT NON CLUSTER INDEX WORK DYNAMICALLY.
| Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
Does any body please help me what question's have asked for SSRS in the interview?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What is row_number () and partition by in sql server?
What is simple indexing method?
What are the different authentication modes in sql server? How can it be changed?
What is the difference between for trigger and after trigger?
What is check constraint in sql server?
Delete duplicate rows without using rowid.
How much memory that we are using in Logshipping Concept?
Explain four layers of abstraction microsoft architectured?
How can you list all the columns in a database?
What is a primary key?
Define ACID properties in a Database?
Which are the important points to note when multilanguage data is stored in a table?
How to modify an existing user defined function?