Subject | Re: [firebird-support] Slower fetchall after creating indices |
---|---|
Author | Ann W. Harrison |
Post date | 2006-07-03T16:34:13Z |
jasperelzinga wrote:
What is the plan for the query with and without the index?
Part of the problem could be caching. The first query
starts with no pages in cache and leaves the cache with
a number of interesting pages.
Regards,
Ann
What is the plan for the query with and without the index?
Part of the problem could be caching. The first query
starts with no pages in cache and leaves the cache with
a number of interesting pages.
Regards,
Ann