reindex or update stat

Hi
I have a database that will have couple thousands row inserted normally, but there will be 3 or 4 days in a year that will have 20000 row inserted daily. I set up the Maintenance Plan to have Optimizations to reorganize the data and index, and it runs once a week. During that busy week how can I imporve the performance? ThanksJen,
20,000 rows is really not all that many and will most likely not cause a
change in the way the queries are run. It's possible but not enough to get
excited about. The once a week will most likely be fine.
--
Andrew J. Kelly
SQL Server MVP
"Jen" <anonymous@.discussions.microsoft.com> wrote in message
news:1FB99858-33E7-43A8-A561-51BD048C53F6@.microsoft.com...
> Hi,
> I have a database that will have couple thousands row inserted normally,
but there will be 3 or 4 days in a year that will have 20000 row inserted
daily. I set up the Maintenance Plan to have Optimizations to reorganize the
data and index, and it runs once a week. During that busy week how can I
imporve the performance? Thanks|||Thanks. In the past we did experience some problem in that few days. actually it's about 60,000 in one table, and every record in this table will be doubled in another table, that is 120,000. How much will be the red line?
-- Andrew J. Kelly wrote: --
Jen
20,000 rows is really not all that many and will most likely not cause
change in the way the queries are run. It's possible but not enough to ge
excited about. The once a week will most likely be fine
--
Andrew J. Kell
SQL Server MV
"Jen" <anonymous@.discussions.microsoft.com> wrote in messag
news:1FB99858-33E7-43A8-A561-51BD048C53F6@.microsoft.com..
> Hi
> I have a database that will have couple thousands row inserted normally
but there will be 3 or 4 days in a year that will have 20000 row inserte
daily. I set up the Maintenance Plan to have Optimizations to reorganize th
data and index, and it runs once a week. During that busy week how can
imporve the performance? Thank|||That's imposable to tell without a breakdown of the data. Essentially if
the selectivity of the new data is about the same as the existing data it
will most likely not be any different. If it is drastically different there
may be some changes in the plans. But in either case if you have auto
update statistics turned on sql server should deal with it appropriately.
If not or you just don't want to leave it to chance you can simply issue an
update stats when your done with the import. If the data being imported is
going to cause a lot of page splits you may just want to reindex afterwards.
The number of rows is not the main deciding factor in if it will affect
performance. It's more the type of data, the schema and the way it is
imported.
--
Andrew J. Kelly
SQL Server MVP
"Jen" <anonymous@.discussions.microsoft.com> wrote in message
news:DF02E261-55FC-4AB1-A170-FE1B51128260@.microsoft.com...
> Thanks. In the past we did experience some problem in that few days.
actually it's about 60,000 in one table, and every record in this table will
be doubled in another table, that is 120,000. How much will be the red line?
> -- Andrew J. Kelly wrote: --
> Jen,
> 20,000 rows is really not all that many and will most likely not
cause a
> change in the way the queries are run. It's possible but not enough
to get
> excited about. The once a week will most likely be fine.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Jen" <anonymous@.discussions.microsoft.com> wrote in message
> news:1FB99858-33E7-43A8-A561-51BD048C53F6@.microsoft.com...
> > Hi,
> > I have a database that will have couple thousands row inserted
normally,
> but there will be 3 or 4 days in a year that will have 20000 row
inserted
> daily. I set up the Maintenance Plan to have Optimizations to
reorganize the
> data and index, and it runs once a week. During that busy week how
can I
> imporve the performance? Thanks
>
>