Make Query Table tool

Discussion created by Riverside on Oct 21, 2010
Latest reply on Oct 22, 2010 by Riverside
I recently tried to use the Make Query Table, thinking that its kinda like the Spatial Views in sde command line, but in ArcMap, and I was using a layer with over 700,000 parcels, with multiple tables, which each have around a million records.  The process ran for 23 hours before I killed it because it sucked up about 23 GBs of memory in my Local Setting Temp directory.  Is this the expected behavior of the Make Table Query or perhaps I am misusing this tool, and should stay with sde command line, which takes a few seconds to process this much data.