hI ,

I AM trying to avoid full table scan on a query, though i am indexing all the columns used in the statement, it is still doing full table scan.
please can you let me know how do i proceed to stop full table scan.

ram