Oracle Optimizer

Follow:

• RSS
• Facebook
• Twitter
• LinkedIn
• Youtube
• Instagram

Statistics

Use Extended Statistics For Better SQL Execution Plans

Nigel Bayliss 9 minute read

Why do I have SQL statement plans that change for the worse?

Nigel Bayliss 6 minute read

Efficient Statistics Maintenance for Partitioned Tables Using ...

Nigel Bayliss 10 minute read

Locked Optimizer Statistics – A Useful Tool in Your Toolbox

Nigel Bayliss 2 minute read

How does AUTO_SAMPLE_SIZE work in Oracle Database 11g?

Hong Su 5 minute read

How does the METHOD_OPT parameter work?

Maria Colgan 7 minute read

Fixed Objects Statistics and Why They are Important

Maria Colgan 3 minute read

Maintaining statistics on large partitioned tables

Sunil Chakkappen 5 minute read

Dynamic sampling and its impact on the Optimizer

Nigel Bayliss 7 minute read

How does AUTO_SAMPLE_SIZE work in Oracle Database 12c?

Nigel Bayliss 4 minute read

Concurrent Statistics Gathering

Maria Colgan 5 minute read

Extended Statistics

Maria Colgan 5 minute read

View more

Receive the latest blog updates

Subscribe to Oracle Connect email updates