Hi all, how can increase the perfromace of the following query
the select return 300000 row in 6 minuts and there is a primary index on ID field for each table
thanks.
CREATE TABLE DB.TABLE3
AS
(
SELECT
b.ID,
b.FILED1,
b.FILED2,
b.FILED3,
b.FILED4,
b.FILED5,
b.FILED6,
b.FILED7,
b.FILED8...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.