Re: [ADSM-L] Speeding up my SQL query

Subject:	Re: [ADSM-L] Speeding up my SQL query
From:	Richard Sims <rbs AT BU DOT EDU>
To:	ADSM-L AT VM.MARIST DOT EDU
Date:	Fri, 16 May 2008 09:07:55 -0400

Eric -

One thing you can do is use the SQL clause IN rather than a succession
of OR conditions to improve the query performance of testing for
multiple values.

  Richard Sims

<Prev in Thread]	Current Thread	[Next in Thread>
[ADSM-L] Speeding up my SQL query, Loon, E.J. van - SPLXM Re: [ADSM-L] Speeding up my SQL query, Richard Sims <= Re: [ADSM-L] Speeding up my SQL query, Loon, E.J. van - SPLXM Re: [ADSM-L] Speeding up my SQL query, Choudarapu, Ramakrishna (GTS) Re: [ADSM-L] Speeding up my SQL query, Richard Sims Re: [ADSM-L] Speeding up my SQL query, Choudarapu, Ramakrishna (GTS) Re: [ADSM-L] Speeding up my SQL query, Loon, E.J. van - SPLXM Re: [ADSM-L] Speeding up my SQL query, Thomas Denier

Previous by Date:	[ADSM-L] Speeding up my SQL query, Loon, E.J. van - SPLXM
Next by Date:	Re: [ADSM-L] Speeding up my SQL query, Choudarapu, Ramakrishna (GTS)
Previous by Thread:	[ADSM-L] Speeding up my SQL query, Loon, E.J. van - SPLXM
Next by Thread:	Re: [ADSM-L] Speeding up my SQL query, Loon, E.J. van - SPLXM
Indexes:	[Date] [Thread] [Top] [All Lists]