Archives of the TeradataForum

Message Posted: Thu, 28 Aug 2008 @ 17:08:23 GMT

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

If you can supply even one fixed date against the PPI table it would help. For example, if the PPI table goes back three years and the other table only three months, put in the SQL that the partitioning column is >= 4/1/2008. You can't always do this, but anything you can do to let the optimizer eliminate partitions will help.

If you can, read the Orange Book on PPI Usage - there's a table in it with examples of query speed against non-PPI and different-grained PPI tables. You can get a pretty good sense of how you're hurt by not specifying values against the partitioning column.

Dave

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