Statistics

How does AUTO_SAMPLE_SIZE work in Oracle Database 11g?

How does AUTO_SAMPLE_SIZE work in Oracle Database 11g?

Hong Su 6 minute read
How does the METHOD_OPT parameter work?

How does the METHOD_OPT parameter work?

Maria Colgan 8 minute read
Maintaining statistics on large partitioned tables

Maintaining statistics on large partitioned tables

Sunil Chakkappen 6 minute read
Efficient Statistics Maintenance for Partitioned Tables Using Incremental Statistics – Part 1

Efficient Statistics Maintenance for Partitioned Tables Using ...

Nigel Bayliss 11 minute read
Incremental Statistics Maintenance – what statistics will be gathered after DML occurs on the table?

Incremental Statistics Maintenance – what statistics will be gathered ...

Nigel Bayliss 4 minute read
I thought the new AUTO_SAMPLE_SIZE in Oracle Database 11g looked at all the rows in a table so why do I see a very small sample size on some tables?

I thought the new AUTO_SAMPLE_SIZE in Oracle Database 11g looked at ...

Maria Colgan 4 minute read
Use Extended Statistics For Better SQL Execution Plans

Use Extended Statistics For Better SQL Execution Plans

Nigel Bayliss 10 minute read
How does the Oracle Database choose what histograms to create?

How does the Oracle Database choose what histograms to create?

Nigel Bayliss 9 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
Extended Statistics

Extended Statistics

Maria Colgan 5 minute read

Receive the latest blog updates

Resources for
Why Oracle
Learn
What's New
Contact Us