IBM Mainframe Forum

Hi,

Is it advisable to use WHERE Clause in a SELECT Query when we already know that the records which will be filtered out are negligible as compared to the number of records which will qualify.

In my case i am using primary key field in WHERE Clause.

Please suggest.

Regards,
Saurabh

Hello,

What will be done with the info that is selected? If the process is basically sequential it is often better to unload the table and work with the unloaded data. Depends on if there are other db tables referenced.

Personally, I believe it is better to code the WHERE.