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

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1109

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1016

What is the sql profiler?

940

What is an indexed view?

960

What are the differences between triggers and stored procedures?

1070

How to test values returned by a subquery with the in operator?

1197

How do you test your database? : sql server database administration

1021

What are the different types of sql server replication? : sql server replication

1272

What is dirty page?

973

How to query multiple tables jointly?

991

How is a full-text index updated?

954

What happens if time-only values are provided as date and time literals?

1019

When you use @@error and try-catch?

1043

How to execute multiple stored procedures at one time in sql server?

1011

What are difference between Cluster index and Non-Cluster index?

1080