I found an error from my yesterdays post:
Basically, in 9i there are four ways of finding out how many rows will any
query return:
1) select from the query and count
2) use v$sql_plan_statistics column output_rows for already executed
queries
output_rows shows cumulative outrows statistics
can someone send me the query I use to hit v$sql_plan to get my estimated cardinality
for a query?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
[EMAIL PROTECTED] wrote:
can someone send me the query I use to hit v$sql_plan to get my estimated
cardinality for a query?
@$ORACLE_HOME/rdbms/admin/utlxpls.sql
or
$ORACLE_HOME/rdbms/admin/utlxplp.sql if you have parallelism.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see
i need to return the cardinality estimate to the user as a number. how do i do that?
From: Stephane Faroult [EMAIL PROTECTED]
Date: 2003/12/29 Mon PM 04:29:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: getting estimate of result set from v$sql_plan
[EMAIL
estimate of
result set from v$sql_plan
[EMAIL PROTECTED]
.com
need to return the cardinality estimate to the user as a number. how do
i do that?
From: Stephane Faroult [EMAIL PROTECTED]
Date: 2003/12/29 Mon PM 04:29:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: getting estimate of result set from v$sql_plan
that?
From: Stephane Faroult [EMAIL PROTECTED]
Date: 2003/12/29 Mon PM 04:29:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: getting estimate of result set from v$sql_plan
[EMAIL PROTECTED] wrote:
can someone send me the query I use to hit v$sql_plan to get
Hi!
Comments below:
let me be clearer. I need to return an
estimate of the number of rows for 'pagination'. The user will page
through 25 rows a time, but wants an estimate on the total number of
rows returned. I want to avoid counts. tom kytes book says to
use v$sql_plan, but how do i
I'll add the missing part to oneof statements in the beginning of my
last mail:
3rd is probably quite inaccurate, especially when histograms aren't
calculated on non-single row predicate columns (again,with bind
variables is useless). Also, if you want to use it, you have to find