Archives of the TeradataForum
Message Posted: Mon, 10 Sep 2001 @ 17:53:57 GMT
| Subj: | | Re: SELECT vs. Temporary Table |
| |
| From: | | James Judge |
Since you said you are on one server then you have both databases within one instance of Teradata; therefore the joining across databases
is a non-issue. It does not matter to Teradata in which database a table/view resides (other than access rights). Temporary tables can
only be created in the user's (the username in the logon/connect) database.
Not sure what you mean by Indexed Views?
| 
