Who's On?

	Membership:
	Latest: Zac Shields
	Past 24 Hours: 1
	Prev. 24 Hours: 1
	Overall: 5210

	People Online:
	Visitors: 315
	Members: 0
	Total: 315

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

Oracle 9i Database index vs data

1 Replies

0 Subscribed to this topic

27 Subscribed to this forum

Sort:

Author

Messages

jdl

Advanced Member

Posts: 20

12/2/2008 8:24 PM

We are running Oracle 9i. The storage is odd in that the data PROD81DATA.dbf file is about 21.5G, but the index PROD81INDX.dbf and PROD81INDX02.dbf is 34G. Why is the index datafiles larger than the data datafile?

John Henley

Posts: 3353

12/2/2008 8:37 PM

That is typical and nothing to be alarmed about. Indexes often take more storage space than tables. What causes it is that you can have tables with lots of rows and lots of indexes. For example, if you have 10 indexes on GLTRANS and you have 10 million rows, you're storing 10 million + (10 * 10 million) = 110 million rows in the database. Although each row of data might be 1000 bytes long, the indexes are usually shorter, but when you consider 10 indexes each storing some part of each row, it adds up...