Archives of the TeradataForum
Message Posted: Wed, 08 Jan 2004 @ 00:25:34 GMT
I am just curious about the following:
1. Have you tried to rewrite the slow query as
SELECT * FROM (SELECT * FROM OBC_MASTER.VW_RECONTACTS WHERE OCID = 9 AND MID = 48 ) T WHERE T.ACT IN (1,2) ; ?
2. Did you ever run your original queries without _any_ statistics collected on the four base tables? What are the run times of fast and slow queries then?
3. What is the result of the following query
select count(*) from OBC_MASTER.FA_OBC_MDN_MTD where ACTIVITY_CODE in (1,2) ; ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|