0

Having to query several steps to get a "totals" result, I used a cte and I have also used a subquery with OVER (PARTITION BY) command.

Which query, the cte or the subquery with OVER (PARTITION BY) would be best to create a VIEW in order to avoid re-running all the calculations each time. Thank you!

I haven't yet created the VIEW. I am just learning how.

Improve this question
Related questions
1
SQL - Using CTEs I get Subquery returned more than 1 value error. This is not permitted when subquery follows =, >,... etc
4
PostgreSQL CTE/Sub-Query with generate_series performance issues
0
h2db: can I use parameterized WITH clauses (CTEs) in subqueries
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.