For which relational operators in where clause, index is not used ?

6 like 0 dislike

Hello

For which relational operators in where clause, index is not used ?

Please give me your feedback......

asked 1 year ago by rad_joshep (19,390 points)

1 Answer

2 like 0 dislike

Best answer

<> , like '% ...' is NOT functions, field +constant, field || '' this types index are not used

answered 1 year ago by daneim (127,080 points)

5 like 0 dislike

1 answer

asked 1 year ago by mafia (1,300 points)

5 like 0 dislike

1 answer

asked 1 year ago by marck_don (191,010 points)

3 like 0 dislike

2 answers

What is an Index ?

asked 1 year ago by daneim (127,080 points)

4 like 0 dislike

1 answer

asked 1 year ago by marck_don (191,010 points)

8 like 0 dislike

1 answer

asked 1 year ago by sr_webmaster (21,000 points)