|
|
Posted by MC on 11/18/05 14:02
I dont understand.
Do you mean to say that you put clustered indeks on a number of columns in
the table to make it ordered? Thats a mistake, you must use order by clause
in a query to ensure that it is ordered. Furthemore, indeksing a large table
is not something you should do lightly, clustered indeks is (if it can be)
in memory and its key is in the nonclustered indexes so if the key of the
clustered indeks is large, your performance will suffer. Not to mention the
data changes (insert, update..)
Please post more info about your situation so we can help some more.
MC
"vibha vyas" <vyas.vibha@gmail.com> wrote in message
news:1132297991.742116.21620@g49g2000cwa.googlegroups.com...
> 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
>
Navigation:
[Reply to this message]
|