Subject | Re: [IBO] Why is it a full table scan? |
---|---|
Author | Jason Wharton |
Post date | 2003-12-23T01:10:40Z |
> My IB_Query holds:For one thing, it appears your KeyLinks are not set.
> 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 ]
Nor have you configured the OrderingLinks with a POS attribute.
Jason Wharton