Performance Tuning

Oracle Query Tuning – Example 3

In this query tuning example we will see how to index table columns null value to improve the performance of query. Many developers writes queries which has filter condition as NULL i.e. they are quering the tables with something IS

Oracle Query Tuning – Example 2

Day by day technology is upgrading and every organization tries to make easy way of communication for their customers. In our day-today life when we make any payment, Recharge Mobiles etc, we get notification on mobile phone via SMS. These

Oracle Query Tuning – Example 1

In this post I am going to share one oracle query tuning example. Query: —————————————————- SELECT MIN (BATCH_DATE), MAX (BATCH_DATE) FROM SA.BATCH_DTLS WHERE ONLINE_BATCH_IND = ‘O’; —————————————————- Environment Details: ——————– Database Version : 9.2.0.8 Operating System : Solaris Table Statistics: