Inconsistency in execution

Hello. What is the diference in next 2 Sql ? It seems to return different results … Thanks a lot for help.

select * from task where status like ‘VERIFY’


  • FETCH FROM CLASS task
    • FETCH FROM CLUSTER 41 ASC
    • FETCH FROM CLUSTER 42 ASC
    • FETCH FROM CLUSTER 43 ASC
    • FETCH FROM CLUSTER 44 ASC
    • FETCH NEW RECORDS FROM CURRENT TRANSACTION SCOPE (if any)
  • FILTER ITEMS WHERE
    status LIKE ‘VERIFY’
  • CALCULATE PROJECTIONS

select * from task where status=‘VERIFY’


  • FETCH FROM INDEX Task.status
    status = ‘VERIFY’
  • EXTRACT VALUE FROM INDEX ENTRY
    filtering clusters [43,44,42,41]
  • FILTER ITEMS BY CLASS
    task
  • CALCULATE PROJECTIONS

image

image