CLUSTER INDEX BCZ THAT WORK PHYSICALLY(MEANS ALREADY IN DEC OR ASC ORDER)

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

Question Posted / jabamit

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

Please Help Members By Posting Answers For Below Questions

Does any body please help me what question's have asked for SSRS in the interview?

2086

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?

963

What is row_number () and partition by in sql server?

1004

What is simple indexing method?

970

What are the different authentication modes in sql server? How can it be changed?

1023

What is the difference between for trigger and after trigger?

1024

What is check constraint in sql server?

955

Delete duplicate rows without using rowid.

1490

How much memory that we are using in Logshipping Concept?

1727

Explain four layers of abstraction microsoft architectured?

147

How can you list all the columns in a database?

886

What is a primary key?

899

Define ACID properties in a Database?

1004

Which are the important points to note when multilanguage data is stored in a table?

910

How to modify an existing user defined function?

1032