Database Tuning (MOSC)

MOSC Banner

Estimated Row Count of a Query ?

edited Jul 12, 2012 6:52AM in Database Tuning (MOSC) 11 commentsAnswered
Hi,

We have a situation where we want to get the row count (as close as possible) to the Query we are trying to execute.  I wanted to know what would be the best way to obtain that count.  I tried to use the cardinality from explain plan, but that appears to be a far off values.

Is there any ways to obtain that count without executing the query ?

Any help will be appreciated.

Thanks,

Sanjay

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center