Previous Topic: Large Tables for User DataNext Topic: Estimate CSE Size

Capacity Planning › Schema Tables › Relative Size of Indexes to Tables

Relative Size of Indexes to Tables

The percentages provided in the following table are based on relative row lengths. For example, the row length of Index 1 for the DASC table, is 35 percent of the row length of the DASC table, or Object Association table.

Table Name

Index 1

Index 2

Index 3

Index 4

DASC

35%

25%

35%

N/A

DCKOHIST

47%

N/A

N/A

N/A

DCKOID

10%

20%

20%

N/A

DGRPUS

100%

100%

N/A

N/A

DMAX

3%

N/A

N/A

N/A

DMDL

3%

28%

N/A

N/A

DMDLUS

40%

40%

N/A

N/A

DNAME

2%

20%

N/A

N/A

DOBJ

2%

20%

6%

4%

DSUBDF

50%

50%

N/A

N/A

DSUBEX

42%

42%

42%

N/A

DSUBID

6%

56%

N/A

N/A

DSUBUS

39%

39%

51%

N/A

DTXT

1%

N/A

N/A

N/A

DUSER

14%

N/A

N/A

N/A