Non Clustered Index by Default.

Which index created when Create Index on table(col), Why

Question Posted / indexes

Answer Posted / indexes

Is This Answer Correct ?

15 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1135

Explain about analysis services?

1043

What is difference between index seek vs. Index scan?

1146

How to query multiple tables jointly?

978

How retrieve field names from the table in SQL through JAVA code?

1897

What is faster join or union?

1192

What is xdr?

982

Explain index in sql server?

1006

Why use sub query in sql server and list out types of sub queries?

992

What is the stored procedure?

1001

What is recompile sql server?

1028

Can you use order by when defining a view?

966

How to create stored procedures with parameters in ms sql server?

1065

Where do we use trace frag?

1005

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2769