Hi,
one mf my processes is going slow. So after tracing the session i found that
in one of the queries this condition is there (WHERE IN_FLAG IS NULL)

SELECT ROWID,XYZ FROM TABLE_NAME WHERE IN_FLAG IS NULL

Some how i tried but tkprof is not giving explain plan for this statement
following are stats

SELECT ROWID,XYZ FROM TABLE_NAME WHERE IN_FLAG IS NULL

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- -------
Parse 0 0.00 0.00 0 0 0 0
Execute 0 0.00 0.00 0 0 0 0
Fetch 110922 2.32 2.03 2738 116800 0 110921
------- ------ -------- ---------- ---------- ---------- ---------- -------
total 110922 2.32 2.03 2738 116800 0 110921

Misses in library cache during parse: 0
Parsing user id: 56 (USER_ID) (recursive depth: 1)

i have a index on IN_FLAG checked the status its valid also
Is there any thing like this index wont get used as we are checking "IS NULL"
If yes how to solve this.......

Thanks in advance.......

Rgds
Parag