0 - 2 of 2 tags for efficiency

I am experiencing efficiency issues when using derived tables in queries.  I can resolve this by breaking up the existing query into smaller queries but I would like to know technical reasons why derived tables would experience efficiency issues.  Typical format: -

Hi,
At my workplace I can't create permanent tables, so I have been creating volatible tables as middle steps for joins later on very large data set.