We have a query that joins 4 large tables and selects data out
based on a where clause. The information is then used to load
into another table. It is way too slow and we can't think of
another way to write the query.
Would creating a view with the join and then drawing data from
the join be faster? Can anybody suggest a better way to do this?
Any suggestions would be greatly appreciated.
Sent using MailStart.com (
http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!
Received on Wed Oct 04 2000 - 19:01:45 CDT
