Archives of the TeradataForum
Message Posted: Fri, 26 Mar 2004 @ 19:46:23 GMT
| Subj: | | Re: SAMPLE syntax |
| |
| From: | | Victor Sokovin |
| | I see your difficulty. SAMPLE assumes that you will want only a portion of the rows. Otherwise, it is much faster to select all the rows
than to sample all of the rows. | |
It looks like the documentation might be more specific about this. I just looked up SQL Ref vol. 6 for R5.0 (the latest one I have right
now):
"fraction_description: any set of unsigned floating point constant numbers in the closed interval (0,1) that specifies the
percentage of rows to be sampled for a true search condition."
I understand "close interval" as though both 0.00 and 1.00 should be included in the "fraction description" but 1.00 seems to fail.
Victor
| 
