Home » SQL & PL/SQL » SQL & PL/SQL » size of tables
size of tables [message #191547] Thu, 07 September 2006 01:53 Go to next message
Anisasama
Messages: 17
Registered: June 2006
Location: karachi, Pakistan
Junior Member

Hi,

We have two tables (table A and table B) and tables are inserted and updated on triggers. Currently table a have 20 million records while table b have 30 million records but size in MB of table A is greater than table B. what is the reason? Table A have 26 columns and Table B have 20 columns.


Thanks
Re: size of tables [message #191552 is a reply to message #191547] Thu, 07 September 2006 02:02 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
sigh.
I think it is the weather that caused it.
Since you haven't provided ANY useful information at all, it is my best guess.
Re: size of tables [message #191625 is a reply to message #191547] Thu, 07 September 2006 06:12 Go to previous messageGo to next message
jaydeep mitra
Messages: 20
Registered: August 2006
Location: India
Junior Member
Hi,
May be the datatypes of columns in table B utilize less memory then A .
Re: size of tables [message #191843 is a reply to message #191552] Fri, 08 September 2006 06:00 Go to previous messageGo to next message
Anisasama
Messages: 17
Registered: June 2006
Location: karachi, Pakistan
Junior Member

what type of information you reqire , plz tell me
Re: size of tables [message #191864 is a reply to message #191843] Fri, 08 September 2006 07:34 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Surely you DO have a slight idea what could cause this difference in size?
Re: size of tables [message #191874 is a reply to message #191547] Fri, 08 September 2006 07:57 Go to previous message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Hi

It could be many things.
First thing to check is the storage parameters, compression etc.
Are You counting indexes into the size?
Have You looked at how much unused space the tables use?
... this was just some very opvious ones.

The way You populate the tables might also have something to say.

Br
Kim
Previous Topic: Transfor FOR LOOP in single INSERT statement
Next Topic: Multiple Inserts
Goto Forum:
  


Current Time: Fri Dec 02 13:50:01 CST 2016

Total time taken to generate the page: 0.38841 seconds