rudy writes: > > Oracle optimizes the queries into almost exactly the same thing. > > thanks for those (output from explain plan?) Yeah, that was from explain plan. > i wonder if we will ever have to use oracle's HINT feature.... I tried playing with hints for the query but it didn't really affect the performance. Dean