Using table buffering

Use of buffered tables is recommended to improve the performance considerably. The buffer is bypassed while using the following statements

1. Select distinct
2. Select … for update
3. Order by, group by, having clause
4. Joins

Use the Bypass buffer addition to the select clause in order to explicitly bypass the buffer while selecting the data.