|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/27/2006 4:09:00 AM
Posts: 3,
Visits: 1
|
|
Hi,
I'm new in teradata. I was told that there is a difference in performance between:
doing a select of a column from a long record and
doing a select of a column from a short record.
is it so?
thanks
ronit
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 10/7/2008 12:54:51 PM
Posts: 116,
Visits: 20
|
|
Yes there is a difference because the data for a long record might be running into multiple blocks, where as the data for a small record might be in just one block. This way when we you do a select the number of blocks that are needed for the select will vary.
This will be true in inserts too. Try to increase the block size this will improve the performance.
Feroz Shaik
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/27/2006 4:09:00 AM
Posts: 3,
Visits: 1
|
|
Hi,
Thanks. I've another question
Is there a difference on the way it manage the spool?
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 10/7/2008 12:54:51 PM
Posts: 116,
Visits: 20
|
|
Spool is nothing but blocks of space that can be used. it does not matter if it is a big record or a small recrod as long as the data can fit in the available spool it should work, once it exceeds the space you will run into spool error.
Feroz Shaik
|
|
|
|
|
Forum Guru
Group: Forum Members
Last Login: 3/27/2007 5:35:00 AM
Posts: 58,
Visits: 1
|
|
Hi
Just for your information, when looking at PERM and Spool space think of the following:
Perm is like a the fuel in your cars tank when you reach it you job fails. Spool on the other hand is like the speed limit ,every one can travel at this speed with out too much problem.
That's All Folks Divvy Certified TeraData Master
|
|
|
|