Re: Antw: Re: [GENERAL] Query questions

2006-07-31 Thread Richard Huxton
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)

Antw: Re: Antw: Re: [GENERAL] Query questions

2006-07-31 Thread Christian Rengstl
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 > >

Re: Antw: Re: [GENERAL] Query questions

2006-07-31 Thread A. Kretschmer
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

Re: Antw: Re: [GENERAL] Query questions

2006-07-31 Thread Richard Huxton
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