Performance issue with NOT LIKE 'VA%' in Sql Query
895550May 2 2012 — edited May 3 2012I'm fetching vendor details from po_vendor_sites_all , in the where clause i use vendor_site_code NOT LIKE 'VA%'. Database:10g
NOT LIKE is reducing the performance, any other option to increase the performance.
Any suggestions?
Thanks
dow005