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

Why truncate is ddl?

1076

How to convert numeric expression data types by assignment operations?

1058

How to select all columns of all rows from a table with a select statement in ms sql server?

1100

How many ways to create table-valued functions?

971

What is a sql join?

1007

Explain the disadvantages of cursors?

1131

What is view in sql?

894

Explain about integration services of Microsoft SQL server?

1024

What is Command line parameters in PLSQL.?

1122

What are the extra roles available in msdb? : sql server security

1122

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1896

How each E-R model constructs can be mapped to the relational model?

990

How the authentication mode can be changed?

1117

Explain Normalization and DE normalization

1099

List out the difference between union and union all in sql server?

978