| Subject | Re: How to rename index without DROP / CREATE |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2006-01-30T12:41:35Z |
--- In firebird-support@yahoogroups.com, "Martijn Tonies" wrote:
that the optimizer chooses a bad plan. But in most cases, we solve
this by hinting/restricting the optimizer through changing our SQL in
some silly way (e.g. by adding 0 or an empty string), rather than
explicitly writing the plan. I have supplied a specific plan in some
circumstances (I think it was once-off queries all the time, so I
didn't bother to check too much if I could solve the plan problem
otherwise), but this is normally not desirable.
Set
> > I need self-defined names as I have to provide my own PLAN for someExpanding on/explaining Martijns question. It isn't all too uncommon
> > selects.
>
> Question 1 would be: why are you using the PLAN clause?
that the optimizer chooses a bad plan. But in most cases, we solve
this by hinting/restricting the optimizer through changing our SQL in
some silly way (e.g. by adding 0 or an empty string), rather than
explicitly writing the plan. I have supplied a specific plan in some
circumstances (I think it was once-off queries all the time, so I
didn't bother to check too much if I could solve the plan problem
otherwise), but this is normally not desirable.
Set