Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Best way to find the count of rows affected by a query

User779842-OracleMay 4 2011 — edited May 4 2011
Hi All,

Is there a way to find the row count without actually executing the SQL statement? The count need not be accurate but it should be within acceptable limits. I know we can use 'explain plan' for this. But the value in plan_table.cardinality is way out of the actual expected count.

We would appreciate any pointers and/or suggestions.

Thanks

Edited by: user779842 on May 4, 2011 2:21 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 1 2011
Added on May 4 2011
#general-database-discussions
12 comments
867 views