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 .
Partitioning -- 3b : More Indexes on Partitioned Table - In the previous blog post, I had demonstrated a Global (Non-Partitioned) Index and a Local (Partitioned) Index. A Global Index itself may be partitioned. ...
Acum 3 ore