<div>
simple way to check:<br />
in SSMS( management studio) click 'Include Actual Execution Plan' icon on top and run the query. Result window will add an extra tab, where you can see the statistics.
</div>


simple way to check:
in SSMS( management studio) click 'Include Actual Execution Plan' icon on top and run the query. Result window will add an extra tab, where you can see the statistics.

<div>
i did that [include actual execution plan]... but i don't know how to read [i mean understand] the information provided
</div>


i did that [include actual execution plan]... but i don't know how to read [i mean understand] the information provided

<div>
<div class="content wysiwyg-content">
dear experts,<br />
<br />
i am using MS SQL SERVER 2008 R2<br />
<br />
i upload 20lac records in a table from a file<br />
this task takes around 1hour or so<br />
this table has 2 index columns on it<br />
<br />
i wanted to ask if rename the table using &quot;exec sp_rename&quot;, will the indexes still work? <br />
i mean... i know they will still exist, but during query execution, will they still be used?<br />
<br />
<br />
also... how do i judge how much an index is being utilised during a query execution of the table where the index is made?<br />
<br />

</div>
</div>


dear experts,

i am using MS SQL SERVER 2008 R2

i upload 20lac records in a table from a file
this task takes around 1hour or so
this table has 2 index columns on it

i wanted to ask if rename the table using "exec sp_rename", will the indexes still work? 
i mean... i know they will still exist, but during query execution, will they still be used?


also... how do i judge how much an index is being utilised during a query execution of the table where the index is made?



index query after renaming table

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.