optimizing join operation
From: Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
Date: Wed, 29 Nov 2023 15:08:30 +0200
Message-ID: <CA+riqSUTp=k-LtjgbnZs9s2mJ26OACrF3gOALGAbsqvj3t1ByA_at_mail.gmail.com>
Dear all,
Date: Wed, 29 Nov 2023 15:08:30 +0200
Message-ID: <CA+riqSUTp=k-LtjgbnZs9s2mJ26OACrF3gOALGAbsqvj3t1ByA_at_mail.gmail.com>
Dear all,
Is there a way to optimize a join in the shape of :
table1 left outer join table2 on table2.colx = substr(table1.coly, - length(table2.colx))
seems like on my 12.1 version DB the optimizer will only pick a NL outer with full scan of table2
Appreciate your answers.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 29 2023 - 14:08:30 CET