Daniel L

My feedback

  1. 148 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  2 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel L commented  · 

    This is a great Idea and a feature I am missing from my days with SAPs SQL Anywhere (ASA).

    "Interactive SQL" which is a T-SQL Editor that can run and analyze statments, allows you to see the following:

    Indexes considered

    -- seq --
    RowsReturned
    7560
    RunTime
    0.018905
    CPUTime
    0.018905
    DiskReadTime
    0
    DiskWriteTime
    0
    DiskRead
    0
    DiskWrite
    0

    -- Table1 UNIQUE (Col1,Col2) --
    Selectivity 0.013227513%
    RowsReturned
    1
    RunTime
    2.5667e-005
    CPUTime
    1e-005
    DiskReadTime
    1.5667e-005
    DiskWriteTime
    0
    DiskRead
    0.0015873
    DiskWrite
    0

    This is a List of the different indexes or "ways to access the requested data".
    And it is awesome to see what was skipped and why.

    Daniel L supported this idea  · 

Feedback and Knowledge Base