Subject Why is it a full table scan?
Author garthtissington
I have a tabel with 50000 books. This table has an index on the
TITLE field



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 ]