H.J. Sanders wrote:
> why not just like in some other (commercial) databases:
>
> a statement to say: use index ............
>
> I know this is against all though but if even the big ones can not resist
> the pressure of their users, why not?
>
Yeah - some could not (e.g. Oracle), but some did (e.g. DB2), and it
seemed (to me anyway) significant DB2's optimizer worked much better
than Oracle's last time I used both of them (Oracle 8/9 and DB2 7/8).
cheers
Mark