Subject | Why is it a full table scan? |
---|---|
Author | garthtissington |
Post date | 2003-12-03T21:20:58Z |
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 ]
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 ]