Re: Optimizing a SQL statement

  • From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
  • To: Stefan Koehler <contact@xxxxxxxx>
  • Date: Fri, 6 Dec 2019 13:43:04 +0300

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+

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 12-2019