Hi guys, I have a problem with indexing in FB. Heres the query select rep$log.pk, tablica_ime, client_number, time_stamp, sql_type, sql_query, usr from rep$log where usr <> 'REPL' and not exists (select rep$trans.pk from rep$trans where rep$trans.replicated_pk = rep$log.pk)
Statistics show that rep$log has all non-indexed reads even though I've created an index for the usr field. What's more interesting is that if I change this line where usr <> 'REPL' and not exists to where usr = 'SYSDBA' and not exists all tha reads are indexed. So the problem is in the <> operation. How can I have indexed reads and keep the <> operation? Thank you in advance guys.
