Subject Re: [firebird-support] Re: SELECT COUNT performance
Author Doug Chamberlin
On 7/10/2010 9:35 AM, sqlsvr wrote:
> Nevermind fixed it. I just checked the index selectivity and it's very low selectivity. When I did the count, I thought the filter used was the primary key (which has a high selectivity) but used a foreign key instead of the primary key.
You're welcome.