Tag: database index

Index is not Used in SELECT

If you realize that index is not used in select, you need to force database to use it. For this, you need to use database hints in your code.  Hints depend on database server. In the following example, here is how to force database to use index when using SAP Trial system (with MaxDB): SELECT *       FROM zaa_bd_wpo_vol...