 |
 |
Archives of the TeradataForum
Message Posted: Wed, 26 Jul 2006 @ 14:19:25 GMT
| Subj: | | Re: Macro call from JDBC for Tactical Queries |
| |
| From: | | Mohommod.Khan |
David, I am little confused as to why you will have to use the temp table....If I follow you , what it is doing is to empty the temp table ,
inserting your desired record and finally reading it that you show using the application interface. Can this not be done using a view or a
derived table that you can tune for performance? Have you thought about it? Now if you do need to store the reultset for the application side
for whatever the reason can you not do that within the Java application instead of doing it on the DBMS? It may be little faster and better way.
Sorry if I have not followed the original thread. Thanks
| |
