Tag Archives: Parallel Query Option

Oracle Parallel Query Option

Last updated on September 14th, 2016 at 09:19 pmWhat Parallel Query Option can perform 1.To speed up access to data by using multiple processes 2.To maximise machine resource usage in query processing 3.To reduce elapsed time by increasing resource usage Operations That Can Run with Parallel Query Option 1.Parallel 2. Full table scans  or table move 3.Fast full index scans 4.Create index or rebuild index 5.Create table … Continue reading Oracle Parallel Query Option »