create index based on another index
From: Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
Date: Wed, 14 Dec 2022 16:43:57 +0200
Message-ID: <CA+riqSX6BLbJfCf7T_bh7VAJjzsf4v-yikooP8tgw4ZuxWYYcg_at_mail.gmail.com>
Hello,
Date: Wed, 14 Dec 2022 16:43:57 +0200
Message-ID: <CA+riqSX6BLbJfCf7T_bh7VAJjzsf4v-yikooP8tgw4ZuxWYYcg_at_mail.gmail.com>
Hello,
I have a situation where an index on a single column is too big (around
25TB) and needs to be partitioned. The plan is to create another index
(global partitioned by hash) on the same column, invisible, then drop the
other non-partitioned index and make the partitioned index visible.
I was thinking now, when the second index is created on the same column,
why is not reading the existing index rather is scanning the table in the
creation process?
Thanks (and sorry if sounds like a stupid question)
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 14 2022 - 15:43:57 CET