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?