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 resistthe 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
