This preview shows page 1. Sign up to view the full content.
Unformatted text preview: not to add one to the number of distinct values for a given column. The database administrator would execute a DBMS utility to gather the current statistics about the database periodically. This is a reasonable approach since the statistics will probably not change too much in a short time. Also, the query optimizer should be able to tolerate some amount of inacurracy in the statistics when searching for the "best" query plan. Pre-Publication Material: This is draft manuscript yet to be copy edited or paged. Copyright AWL2003 81...
View Full Document
This note was uploaded on 09/19/2011 for the course CS 324 taught by Professor Mohammedhajali during the Spring '10 term at Amity University.
- Spring '10
- Image processing