Toad World® Forums

error when running SQL optimizer [1 Attachment]


#1

[Attachment(s) from Wendy Penfold included below]

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;