Use SQL Query analyzer. It will tell you where the slow parts of your query lie.
You may be able to speed it up by indexing certain columns, or by adjusting your joins. The key to fast queries is good database design and logical relationship structures. - James -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of robert Sent: Thursday, June 27, 2002 7:17 AM To: Multiple recipients of list witango-talk Subject: Re: Witango-Talk: sql access question o now that i can do that but i opening this query in access and not in witango we are moving from access to sql but there is still a access application that needs to work on sql so i need to now if there someway to make the query faster in sql ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
