Database Administration (MOSC)

MOSC Banner

Optimizer mechanism to choose best plan

Experts,

As i know Optimizer chooses best plan based on time & cost (time – response time, cost – cpu resource utilization) and then current statistics about data volume , indexes, and joins.

Any other things are considered in background !

Regards,

Thiyagu G

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