Database Problem related Clusterd data

18 Nov 2005 7:14 AM

vibha

Hello sir
We have a very huge database its around 6 lakh records
are being stored in it.
records are not being a sorted order so we checked all
record field through clustering option in Sql server.when we used
clustering records are showing in sorted order but speed of database is
very slow .
i want to know with clustering is there any implecation in database
regading performance od data.Can any one give his views to solve this
problem?and increase the performance of our database.
thanks a lot

18 Nov 2005 1:45 PM

Robert Klemme

vibha wrote:

> Hello sir
> We have a very huge database its around 6 lakh records

^^^^^^
What kind of multiplier is this? ----------------------------+

> are being stored in it.
> records are not being a sorted order so we checked all
> record field through clustering option in Sql server.when we used
> clustering records are showing in sorted order but speed of database
> is very slow .
> i want to know with clustering is there any implecation in database
> regading performance od data.Can any one give his views to solve this
> problem?and increase the performance of our database.
> thanks a lot

Using a clustered index just because you want to get sorted results is not
a good idea. Now, first you need to determine why it's slow. Then you
can take countermeasures. Have a look around

http://www.sql-server-performance.com/default.asp

and especially

http://www.sql-server-performance.com/clustering_2000.asp

Kind regards

robert