The performance of the query may have been a function of the query approach itself, not the presence of the index
From: [email protected] [mailto:[email protected]] Sent: Monday, November 21, 2016 1:19 PM To: [email protected] Subject: RE: [firebird-support] Digest Number 9396 I tested the query on a big database. It was faster if I disabled the index. Tiberiu ---In [email protected]<mailto:[email protected]>, <Sean@...<mailto:Sean@...>> wrote : > 2. the use of index is deliberately blocked, I want to do it this way, my > query > is faster. "Blocked" why? Sean
