Index

Question

Post reply

Index

sunny.tjk

SSCertifiable

Points: 5041
More actions
March 24, 2010 at 12:24 pm

#146109

If there is no clustered index on a table(for ex:25000 records), will it really matter with respect to performance?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95460 More actions · Answer 1

It depends. Are there any non-clustered indexes on that table?

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

sunny.tjk SSCertifiable Points: 5041 More actions · Answer 2

sunny.tjk

SSCertifiable

Points: 5041

March 24, 2010 at 1:27 pm

#1139199

Some of the tables have and some of them dont.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Maybe

A 25000 row table with no indexes at all is going to perform badly, because the only way to find a row is to read all 25000 rows.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass