On Fri, Oct 23, 2015 at 2:40 AM, drci...@yahoo.com [firebird-support] <
firebird-support@yahoogroups.com> wrote:
>
>
> I don't think I understand you fully. Indexed reads a hudreds of times
> faster than non indexed.
>
Yes, when you're looking for a specific value. When you're looking for
Hi, you're wrong. Non-indexed reads are faster than indexed reads. However,
indexed reads may reduce the data that needs to be read and with the right
conditions, it can speed up things tremendously. Let's say you have a table
with breast cancer patients. Using an index for gender would slow
Hello Karol, I don't think I understand you fully. Indexed reads a hudreds of
times faster than non indexed. And the table will have millions of records, so
I do need them.
"then this is cheaper to scan table (500 records) then use 400 indexed reads"
What do you mean scan table? How do I do