A WHERE clause might not be included in the query that is passed to the database. This issue occurs when there is a SAS function on the SELECT clause that cannot be passed to the database for execution. As a result, slower performance might occur because additional rows might be read into SAS before the WHERE clause is processed (rather than being processed by the database).  

To work around this issue, you might be able to alter the query by changing the order of the tables in the query. This change might cause SAS to include the WHERE clause in the query that is submitted to the database.