Archives of the TeradataForum

Message Posted: Thu, 18 Sep 2008 @ 14:53:30 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

You could also do something like this:

     HELP INDEX NEW_CLASS.EMPLOYEE_TABLE;
     Unique? Prim/Sec  Column name  Index No  Apprx Count  Index name  Ordered
     Y           P             Employee_No 1              16.00
     ?                  H
     N          S              Last_name      4
     16.00             ?                  H
     N          S              Dept_No        8
     12.00             ?                  H
     N          S              Hiredate       12
     16.00             ?                  V

     sel * from dbc.tablespace
     where databasename='new_class' and tablename='employee_table'

     Vproc DatabaseName TableName           CurrentPerm PeakPerm
     3        NEW_CLASS   Employee_table    3072.00       3072.00
     2       NEW_CLASS   Employee_table     3072.00       3072.00
     0       NEW_CLASS   Employee_table     3072.00       3072.00
     1       NEW_CLASS   Employee_table     3072.00      3072.00

     After dropping value ordered NUSI on hiredate - 512*4=2048
     Vproc DatabaseName TableName           CurrentPerm PeakPerm
     3        NEW_CLASS   Employee_table    2560.00       3072.00
     2       NEW_CLASS   Employee_table     2560.00       3072.00
     0       NEW_CLASS   Employee_table     2560.00       3072.00
     1       NEW_CLASS   Employee_table     2560.00       3072.00

     After dropping value NUSI on dept_no - 512*4=2048
     Vproc DatabaseName TableName           CurrentPerm PeakPerm
     3        NEW_CLASS   Employee_table    2048.00       3072.00
     2       NEW_CLASS   Employee_table     2048.00       3072.00
     0       NEW_CLASS   Employee_table     2048.00       3072.00
     1       NEW_CLASS   Employee_table     2048.00       3072.00

     After dropping value NUSI on last_name - 512*4=2048
     Vproc DatabaseName TableName           CurrentPerm PeakPerm
     3        NEW_CLASS   Employee_table    1536.00       3072.00
     2       NEW_CLASS   Employee_table     1536.00       3072.00
     0       NEW_CLASS   Employee_table     1536.00       3072.00
     1       NEW_CLASS   Employee_table     1536.00       3072.00

This is a very small table, but I think you get the drift.

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

	<Prev	Next>		<<First	<Prev	Next>	Last>>