Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk

From: Denis <>
Date: Tue, 15 Nov 2011 06:14:31 -0800 (PST)
Message-ID: <>

Thanks all. The caused is identified. The first subquery block in the WITH clause has a where condition:   m_when between  '14-Sep-2011' and '14-Nov-2011'  , where m_when is a DATE type. In SQL Plus, this condition produces zero row, while SQL developer is smart enongh to translate the string to date type, which gives serveral hunderd k number of rows.  
- Denis
Received on Tue Nov 15 2011 - 08:14:31 CST

Original text of this message