Re: what's the SQL for dropping table statistics?

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: 2000/03/01
Message-ID: <38BD1ECB.3F83C44A@edcmail.cr.usgs.gov>#1/1

> I would like to analyze tables for chained rows and then drop
> collected statistics.

ANALYZE TABLE LIST CHAINED ROWS does not compute any statistics so you don't need to drop them. It only figures out which rows are chained and puts the results into the CHAINED_ROWS table (if you use the default).

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Wed Mar 01 2000 - 00:00:00 CST