Computing statistics and query plans

From: <wtgreen_at_my-deja.com>
Date: Tue, 25 Jan 2000 15:11:12 GMT
Message-ID: <86keeb$en4$1@nnrp1.deja.com>

A question for you Oracle gurus out there...

When an "alter table... compute statistics" is issued, does this automatically cause Oracle to recompute the stored query plans that it already has in memory? I come from the Sybase world where is was necessary to issue a recompile command on a table or index after statistics were updated in order to assure that all the in-memory query plans would be recalculated using the new statistics data. I can't seem to find any mention of this in the Oracle documentation, and therefore I am hoping that no such step is necessary. But does anyone know the answer to this definitively?

Thanks

--
Tim Green
ADP, Inc

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 25 2000 - 09:11:12 CST