Re: Question on IO consideration

I heard there exists a table hash clustering kind of concept in oracle but never used it for IO reduction or performance improvement even in 100TB+ size oracle databases i worked on. But I see something matching that thought below. Not sure , to what extent it's used/proved useful in real life scenarios. Others may comment.

http://www.dba-oracle.com/oracle_tip_hash_index_cluster_table.htm

On Wed, Sep 22, 2021 at 12:19 AM Lok P <loknath.73_at_gmail.com> wrote:

> Hello Listers, We have oracle exadata databases which are performing
> mostly warehousing or batch type data processing. And few are hybrid i.e
> combination of both oltp+warehousing/analytics types processing. ETL jobs
> run on a few of these which move/read/write billions rows daily.
> The databases are 50TB to ~150TB in size currently. Few architecture
> team members suggested evaluating if we can use columnar database type of
> offering for IO reduction and thus better performance considering the
> future growth. As per my understanding , Oracle stores data in row format
> only, so is there any other offering from Oracle for columnar datastore
> format or columnar databases and we should evaluate that? Or is there any
> clustering kind of technique which can be evaluated which will help reduce
> IO? Want to understand experts' views here on this.
>
> Regards
> Lok
>

--
http://www.freelists.org/webpage/oracle-l