I had created some indexes for query which was taking too much time and doing full table scan.
But unfortunatly query is not using it.
Query is created dynamicaly, it is created as per user selection. I can not update query. How can I make oracle to use index (assuming that query can not be updated)
Query code is wriiten in application using python.