Archives of the TeradataForum

Message Posted: Mon, 27 Mar 2006 @ 09:33:17 GMT

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

<-- Anonymously Posted: Monday, March 27, 2006 04:32 -->

I would strongly advise talking to your DBAs & systems people on this before you embark on even experimenting with PPIs.

Every opinion and I have heard on PPIs agree that 90% of the effort involved in using PPI is deciding whether or not to use it and how.

Only 10% of your time will be spent actually doing it and maintaining it.

A great deal of planning, analysis of the table's usage and testing permutations will need to be set out and signed off before you can have confidence in your PPI.

When they work they can offer some great advantages, but if the right PPI is not created you can run into very significant performance problems.

Best of luck

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