Re: Slow query when the select list is big

John R Pierce <pierce@xxxxxxxxxxxx> · Sun, 8 May 2016 23:40:37 -0700



    On 5/8/2016 11:09 PM, Sterpu Victor
      wrote:

    
      Yes but it is very big.
      I don't understand why the select list is influencing the CPU
        usage.
      I was expecting that only the join and where clauses would
        influence CPU.
    
    
    what was the query that generated that really complicated execution
    plan?  it sure looks like a really complicated query with lots of
    joins and sorts etc etc..

    
    -- 
john r pierce, recycling bits in santa cruz