Archives of the TeradataForum
Message Posted: Fri, 21 Jul 2000 @ 16:57:42 GMT
| Subj: | | Re: Saturation |
| |
| From: | | Sam Sterling |
Like Rolf says, saturation is a fact of life. Poor performance may not be. It depends a lot on the queries, the data model, and the
indices selected. You might have a Teradata specialist (either from NCR or a good consultant) take a look at those kind of things. I
recently took the average query time in an application from around 20 minutes to around 4.5 minutes and many of the queries from 12 minutes
to less than 6 seconds - just by changing some indices to ones that were used by the bulk of the queries run.
Good luck.
Sam Sterling
www.ssterling.com
Admin Comment: When last tried, the URL in this Post no longer functioned.
| 
