Home Forums SQL Server 2005 Data Corruption Execution plans RE: Execution plans

  • October 10, 2012 at 12:56 am

    #1547481

    ravisamigo (10/9/2012)

    Hi All,

    If query is not using execution plans, how we can find it and what is the action required from DBA side?

    How we can reduce the query cost for select queries with subqueries[ Ex : select * from table1 where empid in ( select * from table2) ]?

    Please help me out on this.

    Thanks and Regards,

    Ravichandra.

    Even the simplest query has an execution plan.

    Action required for what?

    There are no tuning techniques which are specific to subqueries.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]