Hi all,
I have understood that I should not use NE in where clause on a field which is part of primary or secondary index.
But how about using NE in where clause on a field which is not a part of primary or secondary index.
is it ok to use NE? or still i should not use NE.
Some one told me this
Is GT, LT, NE (other than EQ) used as matching criteria while selecting from the database? (Use separate delete statement on Itab to filter those condition.)
Above hold true only for fields which are part of primary or secondary index.
Please validate me!!
Thanks