Re: When should I reorg?

wardellcastles wrote:
> Sorry.. I meant to say... "The time required to read this table
> sequentially has INCREASED significantly....."

Add to the list:

Explain Plan or peferrably a trace and a StatsPack.

What has changed.

Reorganizing a large table, without benefit of metrics, is just a shot in the dark.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)