I have query when i run explain plan , i see several full table scan going on.there are indexes on these tables.how to reduce full table scan on these and use some indexes etc?