Is there a way to speed up Large database searches in SQL?

Rudy Komsic ( (no email) )
Tue, 5 May 1998 02:18:38 -0400


Maybe someone could help me on speeding up SQL Searches. We would like to
offer a from - to period search on our database so our clients can view their
time online. The one problem we are having due to our Huge database is that
it can take several minutes for the results to appear. Is there any SQL
Command that will stop searching after the specified date had passed?

For example:

Our database has information from December 97... and we would like to do a
search from say January to February. But when we run the SQL Query it scans
the WHOLE Database... Is there any way of telling SQL to stop searching after
it Finds March?

Thanks for any
Rudy Komsic
President, Network Administrator - Cyberglobe Communications Inc.
4996 Place de la Savane, Suite 200, Montreal, Quebec, H4P 1Z6
Tel: (514)342-3883 Fax: (514)342-5139 E-Mail: