Performance Tuning

=> Check the performance of Index Skip Scan

=> AWR Comparison Report

=> Create SQL Plan Baselines of High Resource Intensive SQL's from AWR

=> Modify AWR interval and retention periods

=> Using Parallelism in Oracle Database 12C

=> Plan Table in Oracle

=> Column Order in Composite Index

=> Testing Different Access Paths : Concatenated Index

=> Testing Different Access Paths : Compare Single Column Index Access

=> Testing Different Access Paths : With and Without Index