On Sun, Jun 9, 2024 at 1:40 PM Lok P wrote:
> On Sun, Jun 9, 2024 at 10:39 AM Lok P wrote:
>
>>
>>
>> On Sun, Jun 9, 2024 at 10:36 AM sud wrote:
>>
>>>
>>> You can first create the index on the table using the "On ONLY"keyword,
>>> something as below.
>>>
>>> CREATE INDEX idx ON ONLY tab(col1)
On Sun, Jun 9, 2024 at 10:39 AM Lok P wrote:
>
>
> On Sun, Jun 9, 2024 at 10:36 AM sud wrote:
>
>>
>> You can first create the index on the table using the "On ONLY"keyword,
>> something as below.
>>
>> CREATE INDEX idx ON ONLY tab(col1);
>>
>> Then create indexes on each partition in "concurre
On Sun, Jun 9, 2024 at 10:36 AM sud wrote:
>
> You can first create the index on the table using the "On ONLY"keyword,
> something as below.
>
> CREATE INDEX idx ON ONLY tab(col1);
>
> Then create indexes on each partition in "concurrently" from multiple
> sessions in chunks.
>
> CREATE INDEX CO
On Sat, Jun 8, 2024 at 12:53 PM Lok P wrote:
> Hello,
> We have a few tables having size ~5TB and are partitioned on a timestamp
> column. They have ~90 partitions in them and are storing 90 days of data.
> We want to create a couple of indexes on those tables. They are getting the
> incoming tra
Hello,
We have a few tables having size ~5TB and are partitioned on a timestamp
column. They have ~90 partitions in them and are storing 90 days of data.
We want to create a couple of indexes on those tables. They are getting the
incoming transactions(mainly inserts) 24/7 , which are mostly happeni
