Indexes

Hi,
We have a process which deletes and inserts between 100,000 to 150,000
records on a daily basis in 2-3 of our tables. These tables are queried on
certain fields. So we have created some non-clustered indexes on these
tables. The indexes gave us performance gain while querying however, our
deletion and insertion process has now started taking longer time.
To avoid the delay during deletion and insertion process i am planning to
drop the indexes before this process runs and then create them after the
process has ran.
Now the question is - Does dropping and creating indexes on a daily basis
will create any problems?
Thanks and Regards,
Parag> Now the question is - Does dropping and creating indexes on a daily basis
> will create any problems?
As long as your maintenance window allows this, there is no harm in
recreating indexes. Be aware that in the FULL or BULK_LOGGED recovery
model, log space and log backup space requirements will reflect the index
rebuild activity..
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Parag Gaikwad" <Parag Gaikwad@.discussions.microsoft.com> wrote in message
news:4234885A-EF64-482F-B43E-08CA69699B21@.microsoft.com...
> Hi,
> We have a process which deletes and inserts between 100,000 to 150,000
> records on a daily basis in 2-3 of our tables. These tables are queried on
> certain fields. So we have created some non-clustered indexes on these
> tables. The indexes gave us performance gain while querying however, our
> deletion and insertion process has now started taking longer time.
> To avoid the delay during deletion and insertion process i am planning to
> drop the indexes before this process runs and then create them after the
> process has ran.
> Now the question is - Does dropping and creating indexes on a daily basis
> will create any problems?
> Thanks and Regards,
> Parag