Subject Re[5]: [ib-support] Strange query problem
Author Alexander Tabakov
Hello Martijn,

>Do you see DUE_DATE or SERVICE_TAX in the WHERE clase?
>If not - WHY should an index on these fields be used?

DUE_DATE and SERVICE_TAX are not indexed.

>Well, the WHERE clause isn't exactly an easy one and will be executed
>for each row in the PTY table... Happy selecting!

Well I know this, but just can't thinkn of anything more simple.
I must exclude all of the rows in tbl_invalid.

Any sugestions?

Best regards,
Alexander mailto:saho@...