|
|
|
Junior Member
 
Group: Forum Members
Last Login: 1/23/2006 8:36:00 AM
Posts: 16,
Visits: 1
|
|
Hi folks and hapy new year,
Could you tell me how can i get the exact table size, but without indexes size ?
select sum(currentperm) from dbc.allspace where databasename = 'XXXX' and tablename = 'MATABLE' => gives me all space.
Do you know the table name for what i need ?
Thanks.
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 6/16/2007 11:57:00 AM
Posts: 293,
Visits: 1
|
|
From screen 6 of the DBW program.
start ferret
this will start the Ferret application in one of the DBW application windows.
at the ferret prompt type
scope table "mydatabase.mytable" 0
showblocks
quit
The display is very wide. On the right hand side you will find Number of datablocks and Average Datablock size.
Multiply the 2 numbers together and you have the size of the table in Sectors ( Divide the answer by 2 to get Kilobytes )
showblocks /m
will also display lines for each index which you can multiply the same way.
----
|
|
|
|
|
Forum Guru
Group: Forum Members
Last Login: 3/27/2007 5:35:00 AM
Posts: 58,
Visits: 1
|
|
Hi
I generally use the following query to determine table sizes.
select databasename, tablename, sum(currentperm)
from dbc.tablesize
where databasename = 'DBA'
and tablename = 'testing'
group by databasename , tablename;
This will give you the space size of all your part of your table across all AMPS. If you change the query to the follwing below:
select databasename, tablename, currentperm
from dbc.tablesize
where databasename = 'DBA'
and tablename = 'testing'
You can see the space used on each AMP.
Divvy
That's All Folks Divvy Certified TeraData Master
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 1/23/2006 8:36:00 AM
Posts: 16,
Visits: 1
|
|
Ok thanks.
I need just an sql query, only dba have the tools gives in the first answer.
For the second, are you sure this doesn't include indexes size ?
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 6/16/2007 11:57:00 AM
Posts: 293,
Visits: 1
|
|
You can run ferret from Teradata Manager.
|
|
|
|