Because if property = 20, then bitand(prop,4) = 4
etc
hth
connor
--- Sinard Xing <[EMAIL PROTECTED]> wrote: >
Hi all,
>
> If an index with reverse key generated the table
> ind$.property it allways
> store value 4
>
> Why Oracle recommed this condition
>
> WH
Hi all,
If an index with reverse key generated the table ind$.property it allways
store value 4
Why Oracle recommed this condition
WHERE BITAND(ind$.property,4) = 4
instead
ind$.property = 4
PS: This is BITAND () code
int bitand ( int num1, int