re: query optimization/plans

From: <cosmini_at_my-deja.com>
Date: Mon, 21 Jun 1999 14:15:31 GMT
Message-ID: <7klhdp$b9s$1@nnrp1.deja.com>

hi all,
I have a set of 5 tables and a query that's running and takes about 2 minutes to complete. I have another set of 5 tables, of which 4 are common (used on both queries), and the 5th table having the exact same structure but about 1/20th of records as the table in the initial set. The query on the second set of tables takes about 1 hour to run. The interesting thing is that the query plans and cost ARE IDENTICAL on both queries yet the query on the first set (the bigger one) takes a whole lot less time. This is extremely strange.

Am I missing something?

Thanks a bunch,

Cosmin

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 21 1999 - 09:15:31 CDT