Hello Guys,

Am posting two queries here which are exactly same except for an always false condition( 0 = 1) to influence the access path selection, to my surprise i am getting 183 records if the query goes for a table space scan and the number of records fetched is 0 if the index scan happens. I am running the query in DB2 V8 for Z/OS. This is totally baffling as the option of adding a false condition is one of the tuning option suggested...