Subject | Re: Firebird Indexing problem |
---|---|
Author | |
Post date | 2015-10-23T06:40:18Z |
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 that? Like a stored procedure with for select? I don't understand, please explain.