Re: Optimizer Selecting Incorrect Index

Dennis Bjorklund wrote:
> On Wed, 25 Aug 2004, Richard Huxton wrote:
>>
>>These queries are different. The first returns 687 rows and the second
>>713 rows.
>
>
> The 687 and 713 are the number of rows in the plan, not the number of rows
> the queries return.

D'OH! Thanks Dennis

--
   Richard Huxton
   Archonet Ltd