Cost estimation in Oracle 7.3x

From: The Crow <room102_at_hotmail.com>
Date: Mon, 25 Jan 1999 09:12:30 GMT
Message-ID: <36ac329c.90414869@news.barak.net.il>

I need to calculate cost estimation for SELECT queries in Oracle 7.3x.

The EXPLAN_PLAN mechanism -- which uses the PLAN_TABLE -- of the server only provides information about the total cost of the query (i.e.: How long it would take to fetch _all_ the rows).

What I need is an estimation for fetching the first rows (or even simpler - how long would it take to SQLExecute to return?).

Any help would be appreciated.
Thanks. Received on Mon Jan 25 1999 - 03:12:30 CST