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

What methods do you follow to protect from sql injection attack?

1075

How except clause is differs from not in clause?

1008

How to check status of stored procedure in sql server?

1042

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1011

Is the order of columns in the set clause important in ms sql server?

1013

What is the difference between Stored Procedures and triggers?

1133

How many types of objects are there?

1071

Explain how to send email from sql database?

1108

What is the maximum row of a size?

1069

Explain the difference between delete,drop and truncate in SQL Server?

1163

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1090

What are the purposes of floor and sign functions?

1018

What are the lambda triggers?

960

What is openrowset sql server?

1192

How to create a view using data from another view?

997