 |
 |
Archives of the TeradataForum
Message Posted: Fri, 31 Oct 2003 @ 14:23:50 GMT
| Subj: | | Re: CPU for string operations |
| |
| From: | | Meade, Cornelius |
Agreed...Use of concatenation and other string manipulation functions in the where/join clause can often cause the optimizer to
elect to invalidate the use of SI's that might have benefited a differently structured but logically equivalent transaction and
choose to perform a full table scan.
It is also worth noting that while not always the case, I often find that if the business users are doing a lot of this then the
schema/data model in effect may not accurately reflect the real business needs in some way, particularly if you are dealing with
something that has been denormalized. Conversely, this type of thing might be reason to do a bit of denormalizing....
| |
