then this is cheaper to scan table (500 records) then use 400 indexed reads
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Thursday, October 22, 2015 1:13 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Firebird Indexing problem
Hi guys,
I have
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)
