Re: LOL: 122 one column indexes on 122 column table
- From: Stefan Koehler <contact@xxxxxxxx>
- To: laimutis.nedzinskas@xxxxxxxxxxxxxxxxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 Feb 2016 12:53:16 +0100 (CET)
Hi Laimis,
That’s…rude.
… or needed by design. Just think about dynamic queries with all possible
predicate combinations - impossible to create proper (composite) indexes for
all these cases. It may be a valid approach to index each column and let the
optimizer work out the combinations (+ "B-tree to Bitmap Conversions").
They also can be used in joins.
Not everything is as crazy as it looks at first view ;-)
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage:
http://www.soocs.de
Twitter: @OracleSK
Laimutis Nedzinskas <laimutis.nedzinskas@xxxxxxxxxxxxxxxxxxxxx> hat am 19.
Februar 2016 um 10:58 geschrieben:
Hi..
I thought I’d seen all.
Not even close:
122 column table.
122 one-column indexes on EACH column.
(BLOBs I don’t count, let them be)
That’s…rude.
/Laimis N
--
//www.freelists.org/webpage/oracle-l
Other related posts:
