Post reply

Query Behaviour

  • April 4, 2012 at 5:02 am

    #258714

    Hi All,

    I have a Question which may seems to ne naive one but if anyone of the gurus can answere would clear my underastanding.

    I have a Query like the below

    Select *,

    ( select count(*) from Table A1

    from Table A

    Inner Join Table B

  • April 4, 2012 at 6:26 am

    #1468780

    Duplicate post (sort of).

    Replies here please: http://www.sqlservercentral.com/Forums/FindPost1277928.aspx

    -- Gianluca Sartori

  • April 4, 2012 at 7:14 am

    #1468810

    I understand what you are saying but why i am not getting anything in the Execution plan or STATISTICS IO. Does they aggregate the cost and then show??

    The example again is simple but there a number of counts in that query which is using the correlated query joining that huge table with other tables. In that case u suggest i should use the derived table .

    Please suggest as i have to tune the code and that part is actually taking most of the IO

    REgards

    Asit

  • April 4, 2012 at 7:15 am

    #1468815

    please continue discussion in the original topic so your question does not get fragmented accross multiple threads.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply