Which is basically merging 2 tables, whether this query will be faster as both the queries will be invoked at once compared to invoking these queries individually?
For the above query whether 2 execution plan will be created or only one plan will be created? Please clarify.
Other than being syntactically incorrect, that is the best way to do it via SQL. (export/import can be faster in some databases in some cases.) You need to remove the parenthesis for it to work, as the parenthesis denote a column list.
Ideally, however, a column list would be provided. * should only be used in COUNT(), EXISTS(), and ad-hoc queries: INSERT INTO Customer(col1, col2, col3) SELECT col1, col2, col3 FROM Customer Temp;
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads