Re: Query brings system dowh, needs help

Neither of these queries have a usable WHERE clause. Neither, as far as I know, will use an index. Both will do full table scans (YUCH!!!). If you need to, put in a dummy where clause (like ID > 0). Using NOT in the where clause is no help, and the subquery also doesn't use an index. In fact, for each execution of the main stmt, the subquery will probably do a full table scan of its own, once for each of the 20000 records in the table. I think that the MINUS stmts will also do a fts.

-- 
Steve Edelstein                      VOICE: 212-956-3670
Relational Business Systems          CompuServe: 74160,645
124 West 60th Street  Suite 47C            Author of
New York, NY 10023                    "Learning Oracle Forms"