Query 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

Virtual Index in Oracle Database

Virtual index is definition of index which is physically not created that is segment is not created for such index. The main purpose of virtual index is to determine whether the created index would be useful or not for the

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: