Re: Oracle 8i info

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 24 Mar 2005 13:39:13 -0800
Message-ID: <1111700352.973178.117530@f14g2000cwb.googlegroups.com>

Sauro, to add to what Sybrand said:

Did you update the statistics after loading the table and again after deleting large quantities of data from the table? If the CBO thinks the table holds a different number of rows that what is actually there then it could be chosing bad plans to solve your query requests.

This assumes that you have properly indexed the table to begin with.
>From the description in your post it sounds as Sybrand said that you
are missing the proper index.

HTH -- Mark D Powell -- Received on Thu Mar 24 2005 - 15:39:13 CST