Index cluster with one table
From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Fri, 25 May 2012 04:05:34 -0700 (PDT)
Message-ID: <75f08b8f-7a5d-419e-b0db-440830e46ed8_at_t2g2000pbg.googlegroups.com>
A vendor provided scripts for table creation in a new database. Some tables get created in index clusters, however each cluster contains only one table.
Does it make sense? I thought that idea behind clusters was to combine two or more tables
to make joins faster.
Date: Fri, 25 May 2012 04:05:34 -0700 (PDT)
Message-ID: <75f08b8f-7a5d-419e-b0db-440830e46ed8_at_t2g2000pbg.googlegroups.com>
A vendor provided scripts for table creation in a new database. Some tables get created in index clusters, however each cluster contains only one table.
Does it make sense? I thought that idea behind clusters was to combine two or more tables
to make joins faster.
By the way SYS schema also has clusters, and two of them (this is
10.2.0.5) have only one table:
Cluster HISTGRM$ table C_OBJ#INITCOL#
Cluster SMON_SCN_TIME table SMON_SCN_TO_TIME
Received on Fri May 25 2012 - 06:05:34 CDT