Subject Re: [IBO] Why is it a full table scan?
Author Jason Wharton
> My IB_Query holds:
> SQL: select TITLE FROM BOOKS
> OrderItems: TITLE=TITLE;TITLE DESC
> OrderLinks: TITLE=ITEM=1
> SearchingLinks: TITLE=TITLE
>
> I attached an IB_IncrementalSearch with OerdingLInk set to "TITLE"
>
> When I strike any key in this control the Monitor show the following
> snippet for EVERY record in the tabel. Why?
>
>
>
> FETCH
> STMT_HANDLE = 11435500
> FIELDS = [ Version 1 SQLd 2 SQLn 2
> BOOKS.TITLE[TITLE] = 'Beyond Therapy, Beyond Science Vol. 24, No.
> 21 : A New Model for Healing the Who'
> BOOKS.DB_KEY[DB_KEY] = DB_KEY $8200000018BC1100 ]

For one thing, it appears your KeyLinks are not set.
Nor have you configured the OrderingLinks with a POS attribute.

Jason Wharton