Which predicates are stage 1 and indexable?
This is a discussion on Which predicates are stage 1 and indexable? within the DB2 forums, part of the Database Server Software category; --> Hi, i've read that 'Col BETWEEN expr1 and expr2' became stage 1 and indexable in DB2 UDB for z/OS ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 05:43 AM
| ||||
| ||||
 Which predicates are stage 1 and indexable? Hi, i've read that 'Col BETWEEN expr1 and expr2' became stage 1 and indexable in DB2 UDB for z/OS Version 8. Is there any way to find out which predicates are stage 1 and indexable in V7/V8? Had a look in the SQL references but no luck. TIA, Markus      |
|
02-27-2008, 05:43 AM
| |||
| |||
| Re: Which predicates are stage 1 and indexable? Markus Neifer wrote: > Hi, i've read that 'Col BETWEEN expr1 and expr2' became stage 1 and > indexable in DB2 UDB for z/OS Version 8. > > Is there any way to find out which predicates are stage 1 and indexable > in V7/V8? > > Had a look in the SQL references but no luck. > > TIA, Markus The information you need is located in the Administration Guide, which you can download for free from the IBM web site. http://www-306.ibm.com/software/data...s/v7books.html http://www-306.ibm.com/software/data...s/v8books.html Do a search on "predicate types and processing" in the PDF version of the manual. |
|
02-27-2008, 05:43 AM
| ||||
| ||||
| Re: Which predicates are stage 1 and indexable? > The information you need is located in the Administration Guide Thanks a lot! You saved me. I come from DB2 UDB for LUW and it seems that things are quite different with DB2 UDB for z/OS... Greetings, Markus |
Linear Mode
