Joins & Temp space usage
From: Krister D. Ungerboeck <kunger_at_pop.interaccess.com>
Date: 1996/04/12
Message-ID: <316EFECC.1DFF_at_pop.interaccess.com>#1/1
Date: 1996/04/12
Message-ID: <316EFECC.1DFF_at_pop.interaccess.com>#1/1
Am I correct in thinking that sort/merge joins use more temp space than a nested loop join, in general?
Isn't this especially true in a data warehousing star schema type database where you ar generally joining one HUGE table to a number of smaller lookup tables?
Krister D. Ungerboeck Received on Fri Apr 12 1996 - 00:00:00 CEST