what will be right way to deal with this query

[slimdave]

If you can make this an index-organized table on a composite pk of (flnt402,code12) then that would be beneficial.