On Fri, 2004-10-22 at 14:47, Ravi Kongara wrote: > I got to try this in terms of performance. I'm running this program for > more than 100 different tables parallelly. So i have to create so many > temp tables at a time and populate them with the given data and then > run the query by joining with temp tables. I think this increases the > overhead
The key phrase is "I think this increases the overhead..." Test it to be sure. Don't let the DBA catch your parsing those ridiculously long SQL statements. Jared
