Drop automatically-created indexes

Hi
We have a SQL Server 2000 database. On three of the tables (used by an
ERP-system) there are a huge number of automatically-created indexes (we are
hitting the maximum limit). These indexes slow down inserts and updates, and
prevent us from create other (more meaningful) indexes. We have tried to drop
these indexes, but we can’t.
Is there a way to drop/delete automatically-created indexes, or to turn this
functionality off?
Or to you have other suggestions?
Here is some more information about automatically-created indexes:
http://www.microsoft.com/sql/techinf...utoindexes.asp
--JeyLey
Jey
There are called Statistics. SQL Server creates statistics on columns in
order to
retrieve the data in more efficient way. This article makes it clear how
does it work.You can run sp_updatestatistics system stored procedure to
update automatically reated statistics.For more details please refer to BOL.
eyLey" <JeyLey@.nospam.nospam> wrote in message
news:D288B8DC-2E00-4E68-ADAC-7DBD3DF16837@.microsoft.com...
> Hi
> We have a SQL Server 2000 database. On three of the tables (used by an
> ERP-system) there are a huge number of automatically-created indexes (we
are
> hitting the maximum limit). These indexes slow down inserts and updates,
and
> prevent us from create other (more meaningful) indexes. We have tried to
drop
> these indexes, but we cant.
> Is there a way to drop/delete automatically-created indexes, or to turn
this
> functionality off?
> Or to you have other suggestions?
> Here is some more information about automatically-created indexes:
> http://www.microsoft.com/sql/techinf...utoindexes.asp
> --JeyLey
|||In addition to Uri's post:
You can drop these auto-created statistics using the DROP STATISTICS command. But note that
auto-created statistics can benefit performance.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JeyLey" <JeyLey@.nospam.nospam> wrote in message
news:D288B8DC-2E00-4E68-ADAC-7DBD3DF16837@.microsoft.com...
> Hi
> We have a SQL Server 2000 database. On three of the tables (used by an
> ERP-system) there are a huge number of automatically-created indexes (we are
> hitting the maximum limit). These indexes slow down inserts and updates, and
> prevent us from create other (more meaningful) indexes. We have tried to drop
> these indexes, but we can't.
> Is there a way to drop/delete automatically-created indexes, or to turn this
> functionality off?
> Or to you have other suggestions?
> Here is some more information about automatically-created indexes:
> http://www.microsoft.com/sql/techinf...utoindexes.asp
> --JeyLey