Page 1 of 1

Using WHERE Clause in SELECT Query

PostPosted: Sun Jul 14, 2013 7:38 pm
by saurabhgupta86
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

Re: Using WHERE Clause in SELECT Query

PostPosted: Mon Jul 15, 2013 1:12 am
by dick scherrer
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.