Archives of the TeradataForum

Message Posted: Thu, 04 Nov 2004 @ 22:01:03 GMT

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

We also have access logging requirements, and I asked the same question. The wizard is experimenting with many different index column choices using all the SQL statements in the supplied workload. The wizard uses a "back door" into the parser to do this quickly, so it can gather the costs of running the queries with all the different indexes, then pick the best combination. Firing an accesslog event for each test apparently caused some serious performance problems, so they simply disabled it. I've heard rumors that NCR is working toward a fix in a future release.

BTW, it is possible enable access logging and still do index wizard as long as the workload being analyzed does not fire an accesslog event. For example, you can log all denials and all successes except SELECT, and as long as your workload includes only select you will not see the error.

/dave hough

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