Explain query

Posted on 2007-07-24
Last Modified: 2008-09-08
What can by used to explain a query for performance?
Question by:dougbohl
    LVL 142

    Accepted Solution

    query analyser -> View Execution Plan.
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    the execution plan is the best method
    LVL 5

    Assisted Solution

    Yes indeed its the Execution Plan . Have a look at this tutorial, it would help you as to how to generate one & show you what all to look for.

    Bharat Butani.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now