Hot answers tagged


You can try as below: SELECT name, LISTAGG(item_name, ' ') WITHIN GROUP (ORDER BY item_name) AS item_name FROM item GROUP BY name;


If it was me, I would partition by hour, then you can just drop 24 partitions every day. That is only 744 partitions per month. Then if you query within a relatively short window, you will look at much less data. You may also want to look at your index strategy. My guess is that the cost of maintaining the indexes is too high. IMHO, smaller partitions should ...

Only top voted, non community-wiki answers of a minimum length are eligible