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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend