-------- Original Message --------
Subject: [toad] error when running SQL optimizer
Date: Thu, 11 Feb 2010 16:44:33 -0500
[ Attachment(s) from Wendy Penfold included below]
-------- Original Message -------- Subject:
[toad] error when running SQL optimizer
Date:
Thu, 11 Feb 2010 16:44:33 -0500
From:
Wendy Penfold
To:
toad@yahoogroups.com
Issue:
SQL optimizer is encountering an error and then closing on this sql
statement:
SELECT O.Spriden_pidm
,O.Spriden_id
, O.Spriden_last_name
|| ‘, ’
|| O.Spriden_first_name
|| ’ ’
|| O.Spriden_mi
|| ’ ’
|| O.Spriden_id
,O.ROWID
,COUNT (DISTINCT (O.Spriden_pidm)) OVER ()
FROM Spriden N, Spriden O
WHERE N.Spriden_pidm = O.Spriden_pidm
AND N.Spriden_change_ind IS NULL
AND O.Spriden_entity_ind = NVL (’’, O.Spriden_entity_ind)
AND O.Spriden_pidm IN (SELECT Y.Spriden_pidm
FROM Spriden Y
WHERE (Y.Spriden_search_last_name LIKE ‘BOUTWELL’
OR ‘BOUTWELL’ IS NULL)
AND (Y.Spriden_search_first_name LIKE ‘KALI’
OR ‘KALI’ IS NULL)
AND (Y.Spriden_search_mi LIKE ‘’
OR ‘’ IS NULL))
ORDER BY N.Spriden_search_last_name
,N.Spriden_search_first_name
,N.Spriden_search_mi
,N.Spriden_id
,O.Spriden_change_ind DESC;
Hey Wendy,
I can open a support case for you if you’d like, or you can send this over
to the SQL Optimizer Community. The Yahoo group is mostly for the Toad specific
features/screens.
http://sqloptimizeroracle.inside.quest.com/index.jspa
Jeff
Hey Wendy,
I can open a support case for you if you’d like, or you can send this over
to the SQL Optimizer Community. The Yahoo group is mostly for the Toad specific
features/screens.
http://sqloptimizeroracle.inside.quest.com/index.jspa
Jeff
Hi Jeff, thanks. I opened a support case. W
Jeff Smith wrote:
Hey Wendy,
I can open a support case for you if you'd like, or you can send this
over to the SQL Optimizer Community. The Yahoo group is mostly for
the Toad specific features/screens.
http://sqloptimizeroracle.inside.quest.com/index.jspa
Jeff
From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] *On Behalf
Of *Wendy Penfold
Sent: Thursday, February 11, 2010 4:49 PM
To: ToadList
Subject: [Fwd: [toad] error when running SQL optimizer] [1 Attachment]
[Attachment(s) from Wendy Penfold included below]
-------- Original Message --------
*Subject: *
[toad] error when running SQL optimizer
*Date: *
Thu, 11 Feb 2010 16:44:33 -0500
*Hi Jeff, thanks. I opened a support case. W Jeff Smith wrote: Hey Wendy, I can
open a support case for you if you’d like, or you can send this over
to the SQL Optimizer Community. The Yahoo group is mostly for the Toad
specific features/screens. http://sqloptimizer oracle.inside. quest.com/
index.jspa Jeff
att1.dat (10 KB)
Hi Jeff, thanks. I opened a support case. W
Jeff Smith wrote:
Hey Wendy,
I can open a support case for you if you'd like, or you can send this
over to the SQL Optimizer Community. The Yahoo group is mostly for
the Toad specific features/screens.
http://sqloptimizeroracle.inside.quest.com/index.jspa
Jeff
From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] *On Behalf
Of *Wendy Penfold
Sent: Thursday, February 11, 2010 4:49 PM
To: ToadList
Subject: [Fwd: [toad] error when running SQL optimizer] [1 Attachment]
[Attachment(s) from Wendy Penfold included below]
-------- Original Message --------
*Subject: *
[toad] error when running SQL optimizer
*Date: *
Thu, 11 Feb 2010 16:44:33 -0500
*Hi Jeff, thanks. I opened a support case. W Jeff Smith wrote: Hey Wendy, I can
open a support case for you if you’d like, or you can send this over
to the SQL Optimizer Community. The Yahoo group is mostly for the Toad
specific features/screens. http://sqloptimizer oracle.inside. quest.com/
index.jspa Jeff
att1.dat (13.2 KB)