Short answer - LIKE %and% might use an index but just starts scanning at the front of the index and continues until it finds the first row that matches. So your timeout will depend on how many rows have to be bypassed not on the number of rows you fetch. All this processing occurs in DB2 for the first or whatever fetch statement.
LIKE 'AND%" will position to the first location in the index that starts with 'AND' and return rows so no rows bypassed by DB2. There is a List prefetch access path that will find all the rows that match and then sort the RID list but if you were getting that every execution would fail. Mike ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
