Stephan Szabo wrote:
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 joined with the larger database of call detai
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 3/1/07, Rob Schall <[EMAIL PROTECTED]> 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 the difference here has to do with using orignum vs destnum as the join
criteria. There must be more intersection
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.
Rob
Stephan Szabo wrote:
> On Thu, 1 Mar 2007, Rob Schall wrote:
>
>
>> Question for anyone...
>>
>> I tried posting to the bugs, and they said this is a better questio
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
> tab
