|
|
Archives of the TeradataForum
Message Posted: Wed, 13 Oct 2004 @ 12:05:46 GMT
Subj: | | Re: Can this query be written more efficient |
|
From: | | Victor Sokovin |
| This method assumes that ALL columns on mtable = ALL columns on table, whereas it might be - John can confirm one way of the other - that
only X & Y are the same (and therefore that row is not needed) | |
Guys, John might be able to confirm it but this is not his query. He is just forwarding anonymous postings from his account. I think this is
part of the problems he is experiencing at the moment. He mentioned them in one of his earlier admin messages.
Regards,
Victor
| |