Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 17 Mar 2008 @ 23:49:27 GMT

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

Subj:   Re: Creating a table with a 0 skew factor
From:   McCall, Glenn David

  I need to create some evenly distributed dummy data tables which will be used to reserve diskspace for capacity on demand.  

Can you use a database? When you create a database it's space will be evenly divided across the system. When you need the space, you could move it to another database. Bear in mind that this will likely require exclusive database level locks.

Why not just give the space to the database that might need it in advance? What value will you get by creating dummy tables in a database filling them with data to "reserve space", only having to implement a process to delete the data when you need the space?

Perhaps I'm missing something.

Also have a look at the hash functions in the "Functions and Operators" manual. You can use these to see where the rows in your table are going to. Example select hashamp( hashrow (pi_val1, pi_val_2)), pi_val1, pi_val2 from dummy_space_table;


Glenn Mc

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020