|Subject||Re: [IBO] Is it possible to change plan of a query?|
I don't think you can use 'SET STATISTICS INDEX indexname' in a stored
> Ehm... that was the problem! With a
> SET STATISTICS INDEX indexname
> to the relevant indexes did the trick! So you Hans were right.
> Wondering why I had no problem pumping data from 1.5 to 1.5 database,
> while I have from 1.5 to 2.0. Wondering if I will still have from 2.0
> to 2.0, but I will build a stored procedure to recalculate selectivity
> or to rebuild the indexes.