[Oracle] SQL to optimize performance

You can try to run the following statement to improve the performance of table querying.

ANALYZE TABLE <table_name> COMPUTE STATISTICS;

If your table is big enough, it will drastically improve the query timing.

This may not be the best way to improve the performance as some school of thought suggested that this is ‘old-fashioned’ way of performance optimization.

Do read more if you are serious about performance optimization. I found this link which may be useful to you: http://www.stanford.edu/dept/itss/docs/oracle/10g/text.101/b10729/aoptim.htm

Advertisement