| deleting statistics [message #51013] |
Sat, 20 April 2002 03:24  |
RP
Messages: 8
Registered: January 2000
|
Junior Member |
|
|
I run every week analyze and compute statistics for the tables in the dtatbase having several thousands rows. Do I need to run occassionally delete statistics too? If any one has good idea please pass on to me. Is it going for having better performance by deleting the statistics?
Thanks!!!!!!
|
|
|
|
| Re: deleting statistics [message #51024 is a reply to message #51013] |
Sun, 21 April 2002 10:44  |
Mike
Messages: 417
Registered: September 1998
|
Senior Member |
|
|
|
When you generate statistics for a table the existing statistics will automaticly get deleted. So, NO ,you don't need to do it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
