HI all,

I know this question is kinda 'lazy' but just want a quick feedback for a simple question.

I got this long SQL stored procedure that does queries using ".... WHERE regionid = 'E'" and I may have to change it do ".... WHERE regionid LIKE 'E%'" or ".... WHERE regionid in ( 'E1', 'E2', 'E3' .... )" ... will this cause a noticeable affect in so far as SQL query performance is concerned ... ???

Cheers,

EDWIN ONG UY
UNIT 4,64 GRANGE ROAD
MT EDEN 1003
AUCKLAND, NEW ZEALAND
Email: [Email address protected]
Mobile: 64-021-622092

-------------------------------------
This email is intended solely for the named recipient/s and as such is confidential and may contain information that is privileged. If you have received it by mistake, please notify the sender. You must not use, copy, distribute or disclose its contents to anyone other than the addressee. This email and any attachments might not be free from computer viruses or other defects.


DB2 & UDB email list listserv db2-l LazyDBA home page