Helo all, I need explanation on EXPLAIN here.
I am trying to JOIN 2 tables TBL1 and TBL2 on TBL1.fld_id = TBL2.fld_id . And finally I filter out the results that i need in the where clause using where TBL1.fld_col = 100; Running an EXPLAIN shows that it is an impossible where condition. This may be because there may be no rows with fld_col = 100. But in future there could be rows with this value in fld_col. So how should I rate this query? Should I consider this query as a bad one just because it has an impossible where currently? Thanks Ratheesh Bhat K J
