Size of cluster
From: George Reichert <gmr_at_panix.com>
Date: 13 Aug 1994 08:10:15 -0400
Message-ID: <32id77$fgd_at_panix.com>
Date: 13 Aug 1994 08:10:15 -0400
Message-ID: <32id77$fgd_at_panix.com>
I recently asked for help sizing a table. I have a similar question. Let's say I have a table INVOICE. The table consists of the following fields:
invoice_number char(14) page_number number(2) line_number number(3) invoice_line varchar2(80)
I want to put a clustered index on this one table. This will save me space. The cluster will be on invoice_number, page_number. Let's say that I eventually have 100,000 rows in the table. I have approximately 35 rows per cluster key if that's important. Is there an easy way to calculate the size of the table and it's cluster? I'd forever be in your debt. Received on Sat Aug 13 1994 - 14:10:15 CEST