"Derived table" syntax (subquery in FROM clause) - performance issue?
44 views
Skip to first unread message
awo...@silversky.com
Mar 16, 2016, 3:03:28 PM3/16/16
to cstore users
Hello, I am converting queries to CitusDB and have a number of "derived tables" (or "inline views"). For most DBMSes this is a simple transformation but it strikes me there may be a complication to this in CitusDB. Does anyone have information on whether this syntax carries a performance penalty in CitusDB?
Murat Tuncer
Mar 18, 2016, 5:41:57 AM3/18/16
to cstore users
Hey Andrew
Your question is being handled by Citus support.
Murat Tuncer
Mar 18, 2016, 12:54:12 PM3/18/16
to cstore users
Hello
It might be possible to re-write the query to remove inline views. Could you clarify the nature off view a bit ? Does it contain a join, aggregation ? How many inline views are there ? etc.
We can talk about performance implications once we know more about the query.
Reply all
Reply to author
Forward
0 new messages