k_murli_krishna
asked on
ALLOW REVERSE SCAN
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
Query
( 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.
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
Query
( 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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.