| Subject | RE: [firebird-support] Digest Number 9396 |
|---|---|
| Author | Leyne, Sean |
| Post date | 2016-11-21T18:26:02Z |
The performance of the query may have been a function of the query approach itself, not the presence of the index
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Monday, November 21, 2016 1:19 PM
To: firebird-support@yahoogroups.com
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 firebird-support@yahoogroups.com, <Sean@...> wrote :
> 2. the use of index is deliberately blocked, I want to do it this way, my query
> is faster.
"Blocked" why?
Sean