I tried a hint to use a multicolumn index, ran an EXPLAIN, and discovered that it had added another layer of nested joined table scans instead. I am not enthusiastic about hints anyhow, because I am concerned about building such procedural directives into a nonprocedural language, it seems to subvert the data independence of the program. Received on Mon Aug 07 1995 - 00:00:00 CEST
Original text of this message