ALLOW REVERSE SCAN
Posted on 2004-08-28
What does allow reverse scan exactly mean in DB2.
1) It assists queries with columns only in order by clause.
2) It assists if original order of columns is reversed in order by
3) It assists in the sense the column order is same but when asc becomes desc and desc becomes asc
4) Lets say we perform the search
( FolderId LIKE '1%200246' )
DB2 matches from left to right on the search statements. what I was wondering can DB2 create an index that has a reverse byte order .
so instead of searching '1*' it rather searches 642002*
Please clear my confusion.