Archives of the TeradataForum

Message Posted: Wed, 17 Jul 2003 @ 02:33:28 GMT


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

Subj:		Re: Ideas on querying the Call_hist detailed record table

From:		Christian Schiefer

Hi,

not to forget, if you are on R5, you can use PPI. We have a 15 months history partitioned by day. This can be a performance booster depending on the timeframes queried.

But take care: Sloppy code like "where call_date/100 = 10307" is not recognized by the optimizer (we are on 5.0.13 ). Use the "between" and you are on the safe side.

Christian

P.S: For the NCR guys: This would be a nice improvement....