Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk
From: Denis <denis.sun_at_yahoo.com>
Date: Tue, 15 Nov 2011 06:14:31 -0800 (PST)
Message-ID: <1321366471.27699.YahooMailNeo_at_web161804.mail.bf1.yahoo.com>
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
Date: Tue, 15 Nov 2011 06:14:31 -0800 (PST)
Message-ID: <1321366471.27699.YahooMailNeo_at_web161804.mail.bf1.yahoo.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 15 2011 - 08:14:31 CST