Re: Optimizing a SQL statement
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Fri, 6 Dec 2019 13:43:04 +0300
Message-ID: <CAOVevU7w=gq2sOrC0FTQGABTv-h-DyS3g036tj34ZWi2BqOVEg_at_mail.gmail.com>
Date: Fri, 6 Dec 2019 13:43:04 +0300
Message-ID: <CAOVevU7w=gq2sOrC0FTQGABTv-h-DyS3g036tj34ZWi2BqOVEg_at_mail.gmail.com>
If almost all executions have the same selectivity as provided one, use_concat with indexes for all columns from predicates can help him, since he is using 11.2.0.4 as I showed above. Or_expand can help only after upgrade to 12+
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 06 2019 - 11:43:04 CET