On Thu, 1 Mar 2007, Rob Schall wrote:
Question for anyone...
I tried posting to the bugs, and they said this is a better question for here.
I have to queries. One runs in about 2 seconds. The other takes upwards
of 2 minutes. I have a temp table that is created with 2 columns. This
table is
On Thu, 1 Mar 2007, Rob Schall wrote:
There are 4 entries (wanted to make the playing field level for this
test). There are 2 with true for istf and 2 with false.
Then analyzing might help, because I think it's estimating many more rows
for both cases, and with 2 rows estimated to be returned
On Sat, 21 Apr 2007, cluster wrote:
I have investigated a bit now and found the following:
When I perform the update the *first* time, the triggers are actually
not evaluated. But from the second update they are.
Are these in one transaction? If so, then right now after the first
update,
On Wed, 19 Nov 2008, [ISO-8859-5] ??? wrote:
Query 1:
select * from t1 where id not in (select id from t2);
Query 2 (gives same result as Q1):
select * from t1 except all (select id from t2);
It gives the same result as long as no nulls are in either table. If
either table can
101 - 104 of 104 matches
Mail list logo