Oracle Optimizer

How to Generate a Useful SQL Execution Plan

How to Generate a Useful SQL Execution Plan

Nigel Bayliss 8 minute read
Tips on SQL Plan Management and Oracle Database In-Memory – Part 3

Tips on SQL Plan Management and Oracle Database In-Memory – Part 3

Nigel Bayliss 9 minute read
Efficient Statistics Maintenance for Partitioned Tables Using Incremental Statistics – Part 2

Efficient Statistics Maintenance for Partitioned Tables Using ...

Nigel Bayliss 7 minute read
What you need to know about SQL Plan Management and Auto Capture

What you need to know about SQL Plan Management and Auto Capture

Nigel Bayliss 7 minute read
Adding and Disabling Hints Using SQL Patch

Adding and Disabling Hints Using SQL Patch

Nigel Bayliss 6 minute read
Tips on SQL Plan Management and Oracle Database In-Memory Part 1

Tips on SQL Plan Management and Oracle Database In-Memory Part 1

Nigel Bayliss 5 minute read
Tips on SQL Plan Management and Oracle Database In-Memory – Part 2

Tips on SQL Plan Management and Oracle Database In-Memory – ...

Nigel Bayliss 7 minute read
Outerjoins in Oracle

Outerjoins in Oracle

Maria Colgan 9 minute read
Oracle Database 19c and SQL Plan Management Diagnostics

Oracle Database 19c and SQL Plan Management Diagnostics

Nigel Bayliss 3 minute read
Use Extended Statistics For Better SQL Execution Plans

Use Extended Statistics For Better SQL Execution Plans

Nigel Bayliss 10 minute read
Statistics Feedback (Formerly Cardinality Feedback)

Statistics Feedback (Formerly Cardinality Feedback)

Nigel Bayliss 4 minute read
How does AUTO_SAMPLE_SIZE work in Oracle Database 12c?

How does AUTO_SAMPLE_SIZE work in Oracle Database 12c?

Nigel Bayliss 5 minute read

Receive the latest blog updates

Resources for
Why Oracle
Learn
What's New
Contact Us