|Subject||Re: Re: [ib-support] Strange query problem|
> >Do you see DUE_DATE or SERVICE_TAX in the WHERE clase?Sorry - I totally misread your post.
> >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 executedNot right now.
> >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?
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
"This is an object-oriented system.
If we change anything, the users object."