Archives of the TeradataForum

Message Posted: Wed, 08 Jan 2004 @ 00:25:34 GMT

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

Ganga,

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) ; ?

Regards,

Victor

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