Re: How can I tune this query?????

Dear Andrea:

While all of the other suggestions that others have offered may help, what you need is a method to tune these queries. This tuning cannot be done without more information. The first step is to find out how the query is being executed.

What is the "plan" for the query? In Sybase, "set showplan on" will give you this. There is a similar setting in Oracle, although I can't remember what it is at the moment. If you have any table scans going on, make sure that the query requires more than 1/2 the rows of the table to do its work. Make sure you rewrite the query so this is unnecessary, if you can. But see what the database is spending this time on, and then minimize the biggest piece of it. There is no "right" answer to how to tune a database. Try things. Use what works.

Maxxwell M. Cassidy.

-- 
o---------------------------------------------------------------o


|   Maxxwell M. Cassidy,                                        |

|   President,                                                  |


|   Yucca Mist, Inc.                                            |