Thanks, Marist,

Right now it's using the bitmap indexes. Is that causing the increase LIO.

There are no full table scans in the explain plan and all i seee is the index lookups.

Pl Suggest

Badrinath