On Fri, 2007-11-16 at 11:06 -0500, Jonah H. Harris wrote: > On Nov 16, 2007 10:56 AM, Dave Dutcher <dave@xxxxxxxxxxxx> wrote: > > I don't know about that. There are times when it is the right plan: > > Agreed. IMHO, there's nothing wrong with nested-loop join as long as > it's being used properly. I do agree also, but in some other cases, the usage of nested loops (esp when the number of rows estimated to be returned vs the actual number of rows being returned differs by up to 100x (or more) then it becomes a major issue. The example pointed out by Dave D shows the est rows = 1 and actual rows=1, then good performance of course. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
