which are equivalent to two inequalities, which means
select * from mytable where to_date('29-May-2012', 'dd-MON-YYYY') between _from and _to
HimsemaJ wrote:Hi Himanshu
Also, for best performance you can put the most restrictive column value first (the column with the highest unique values) because this will trim-down the result set. So, you index should like as below:
create index i1 on prd_mst(order_no, item_code, locn_code)
order_no is first because this is you primary key, so, this will have all unique values. Then item_code comes next, followed by locn_code.
Bugra Canbakal wrote:Hi Bugra
You can create virtual indexes and see the cost of them