Re: reindex or update stat
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/19/04
- Next message: Johnny: "Re: Restore Database Dialog Shows Old Backup File Location"
- Previous message: Brad: "Books on Full Text Search"
- In reply to: Jen: "Re: reindex or update stat"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 18 Feb 2004 23:32:39 -0500
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 > > >
- Next message: Johnny: "Re: Restore Database Dialog Shows Old Backup File Location"
- Previous message: Brad: "Books on Full Text Search"
- In reply to: Jen: "Re: reindex or update stat"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
