Jon Gardiner wrote:
Analyzing a table requires looking at every
record in the table. If the
table you are dealing with is a large one then
there is a good chance that
after analyzing the table your disk cache will
not contain the records that
you are trying to grab. Once you run the
Analyzing a table requires looking at every record in the table. If the
table you are dealing with is a large one then there is a good chance that
after analyzing the table your disk cache will not contain the records that
you are trying to grab. Once you run the query it will almost certainly