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
"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.