Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Teradata Index Wizard (TIWIZ) interpretation
 
From:   Hough, David A

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023