the database is oltp type ...
The data is distibuted evenly ..

i have indexed tables ,indexes then also it is not using the indexes .On rule based it uses the indexes ....