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

4 Answers
11267 Views
CarrizalSoft Technologies, L&T, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Explain transaction server implicit?

972

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2759

What is de-normalization in sql database administration? Give examples?

965

Tell me can we use custom code in ssrs?

988

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

938

What is default constraint in ms sql server?

1009

How can I change procedure name in sql server?

1037

What is the difference between mysql and mysqli?

1171

How to change the ownership of a schema in ms sql server?

1168

How to make a remote connection in a database?

960

Explain how does the report manager work in ssrs?

939

What is scd (slowly changing dimension)? : sql server analysis services, ssas

996

What are the disadvantages of merge replication?

1392

How do I find the default sql server instance?

928

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

930