SQL Performance (MOSC)

MOSC Banner

sql tuning advisor does not recommend stats gather but Sqlt does.

edited Jun 28, 2016 10:18AM in SQL Performance (MOSC) 2 commentsAnswered ✓

I have observed that sometimes when i run a manual sql tuning advisor for a specific sql....sql tuning advisor does not suggest any stats gather but rather gives an alternate plan.

But when Sqlt is run ...it finds that plan may improve if considered stats gather with a higher percentage of estimate percent on specific tables in the query.

Ques:

Which methodology is better ..gather stats first and run sqltuning advisor to generate a better plan....or directly run sql tuning advisor and accept the plan with high benefit %.

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