![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Fri, 22 Feb 2002 @ 22:52:30 GMT
Subj: | | Re: BTEQ Question |
|
From: | | Geoffrey Rommel |
| Just an observation. At one of my customer sites, we discovered that when you qualify a request and then use SAMPLE, you might get a
FTS anyway. In our testing, it would do the FTS when you qualified with a TIMESTAMP column but with other columns it did the quick
SAMPLE.... | |
I don't claim to know much about this point, but my class notes for Physical Database Design (dated 1996) say, rather cryptically,
"Do not include TIME in any index.... Indexes with TIME are used for insert only, because exact time is unknown." I think they assume that
whenever you use a TIME or TIMESTAMP column in your query, you don't really know the exact time down to the microsecond, so they will ignore
that and do a FTS instead.
--wgr
| |