Using WHERE Processing to Reduce Network Traffic

When using RLS, one of the best ways to reduce the amount of data that needs to move through the network to the client session is to use WHERE statement processing whenever possible. When WHERE statements are used, the WHERE clause is passed to the server environment and interpreted. Only the data that meets the selection criteria is transferred to the client environment for processing.

If the data you are accessing is stored in an external database, the WHERE statement is passed to the database and evaluated, if possible. If the database cannot complete the evaluation, the server completes it before returning any of the data to the client session. For examples of using the WHERE statement, see Example 2. RLS: Accessing Server Data by Using the WHERE Statement , Example 4. RLS: An SCL Program That Uses the WHERE Statement , and Example 6. RLS: Subsetting Server Data for Client Processing and Display .