Skip to Content
0
Former Member
Feb 18, 2009 at 01:07 AM

NE operator in where cluase for non index fields??

459 Views

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