yes.
no of conditions per record is about 4 to 5.
and i can not use any join condition as i have to look up a whole table record in another table.