Eliminate cluster index 1

[Guest_imported]

We eliminated cluster index in all of our tables. Is it a good idea to download and reload the database after that to improve performace ?

Thank yoy

 

[calahans]

Eliminating a clustered index will decrease performance no matter what you do subsequently

Cal

 

[jnicho02]

The physical order of the existing data will be as per the old clustered index.

If you no longer have a clustered index the data won't be re-ordered when you reload it, so it will be a waste of time.

Any new records will now be physically added to the end of the table, thus your inserts will be faster (assuming that your old clustered index wasn't time based). Your retrieval speeds will probably now degrade over time. My Home -->

http://www.geocities.com/jnicho02/

 

[jnicho02]

Hi Cal...I think that we answered at the same time... My Home -->

http://www.geocities.com/jnicho02/

 

[TomSark]

Only remove the clustered index if you have small tables. This is valid for small tables, etc. where it is more efficient to perform a table scan than it is to maintain the overhead of the index.

If you have small tables, (i.e., 10 pages of data or less) then don't use indexes. Tom Davis
tdavis@sark.com

http://www.sarkdallas.com

 

[calahans]

I bow to the last two posts! If you have a small number of rows (below a few thousand) don't place an index on it.



Cal

 

[calico]

Thank you for your help !

Now I realize that it was not a good idea to eliminate all cluster index of our Sql tables (MS Sql Server 7.0).
This suggession came from our supplier to improve performance of the system. We bought this system. We didn't develop this system.

Now I can notice very bad performance. May be contention problem !
Also I identify some supplier's reports that do not work correcyly since have eliminated cluster index.

Can we replace the cluster index without problem ?
Does the time required to replace cluster index is the same as the time that it took to eliminate cluster index ?
Do we have to download and reload database ?

Thank you

Danny (I like very much this forum !)