A. Kretschmer wrote:
am 31.07.2006, um 15:55:39 +0100 mailte Richard Huxton folgendes:
Christian Rengstl wrote:
My version is 8.1.4. Here is the plan for the query, it's performed on a
Total runtime: 1903.894 ms
And yes i have indexes on both pid (varchar(15)
I meant that i have an index on pid and one on crit.
>>> "A. Kretschmer" <[EMAIL PROTECTED]> 31.07.06 17.16
Uhr >>>
am 31.07.2006, um 15:55:39 +0100 mailte Richard Huxton folgendes:
> Christian Rengstl wrote:
> >My version is 8.1.4. Here is the plan for the query, it's performed
on a
> >
am 31.07.2006, um 15:55:39 +0100 mailte Richard Huxton folgendes:
> Christian Rengstl wrote:
> >My version is 8.1.4. Here is the plan for the query, it's performed on a
> >Total runtime: 1903.894 ms
> >And yes i have indexes on both pid (varchar(15)) and crit(va
Christian Rengstl wrote:
My version is 8.1.4. Here is the plan for the query, it's performed on a
smaller table, though because i can't access the biggest table at the
moment:
QUERY PLAN