Subject | Re: How to get best plan for typical Order–Customer? |
---|---|
Author | kokok_kokok |
Post date | 2008-11-15T18:16:49Z |
> It seems you don't have an index for Customers.EntryDate. Is itintentional?
>Yes, it is intentional, in fact, here I used the EntryDate field, but
I can use many other fields, most of them not indexed. The user can
filter by any field, there are many scenarios. The only useful index
must be OrderDate because all consults use always this field. Then,
additionally the user can exclude some rows according his criteria.
Here is when I have the problem, the user wants to exclude for example
customers from Canada, and FB provides a suboptimal plan instead of
using the OrderDate index.