Trick to make query run fast

There may be some actions that need full table scans and takes more time to execute.

Following are certatin such actions:

- Index creation

- Select count(*) from a table ; to get the number of rows

- Gather table statistics

 

To speed up the above queries we need to set the following session parameters and then execute the required action

 

alter session set sort_area_size=536870912;

alter session set sort_multiblock_read_count=128;

alter session set db_file_multiblock_read_count=128;