A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Refactoring for Software Design Smells: Managing Technical Debt
this week in the
OO, Patterns, UML and Refactoring
How to find the current sizes of the tables in a Database?
Joined: Aug 06, 2005
Sep 26, 2007 05:20:00
How to find the current sizes of the tables in a Database. Please any one help me out.
Thanks & Regards,
Priyadharshini . T
Joined: Jan 24, 2006
Sep 27, 2007 10:01:00
checkout Dan Morgans Library page from Puget sound Oracle Users Group on tables:
check out the two queries at the bottom of the page. Excellent resource
Joined: Mar 22, 2005
Sep 27, 2007 11:17:00
Do you mean the number of rows, or something that is measured in KB/MB/GB? If the former, "select count(*) from table" will tell you that.
[ September 27, 2007: Message edited by: Ulf Dittmer ]
Joined: Oct 06, 2007
Oct 06, 2007 21:24:00
If you want to know the number of rows in a table:
WHERE table_name = 'YOUR_TABLE_NAME'
I agree. Here's the link:
subject: How to find the current sizes of the tables in a Database?
names and properties of tables in database using jdbc
Increasing performance through indexing
tables and fields
Listing out tables in a database
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015