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...