Tag Info

New answers tagged

6

It seems to ignore any index I put on it Unless you're using SQL Server Enterprise Edition (or equivalently, Trial and Developer), you will need to use WITH (NOEXPAND) on the view reference in order to use it. In fact, even if you are using Enterprise, there are good reasons to use that hint. Without the hint, the query optimizer (in Enterprise ...


0

If you are using SQL Standard Edition, you have to use the WITH (NOEXPAND) table hint. If you are using Enterprise Edition, you might want to use that hint anyway, to get statistics on the view, and to prevent the optimizer choosing not to use it (see the second link below). You may also want to assess the benefits of adding other nonclustered indexes to ...



Top 50 recent answers are included