In case you have an oracle exadata database machine, always use 100% percent for collecting optimizer statistics on your tables/schemas , in order to benefit from the smart scans .
http://uhesse.com/2012/07/04/no-smart-scan-with-auto_sample_size/
Rownum quiz
-
Here’s a silly little puzzle that baffled me for a few moments until I
spotted my typing error. It starts with a small table I’d created to hold a
few rows...
Acum o zi
Niciun comentariu:
Trimiteți un comentariu