Subject Re: Re[5]: [ib-support] Strange query problem
Author Martijn Tonies
> >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.

Sorry - I totally misread your post.

> >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?

Not right now.

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."