hi all,

where condition of select query uses negati

i am searching by negative number on a particular table , in this case select query scans full table
index is not utilised

If i search by positive number on same column same table
index used

plz reply