Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 index

Author  Topic 

rajnidas
Yak Posting Veteran

97 Posts

Posted - 2014-11-21 : 02:04:49

Hi everyone,

when i execute the sql query(procedure ) in sql server 2012 the query is very slow , some one suggest me to use index and i dont know to how to create & drop a index in sql server pls suggest me.

Thanks
Rajnidas

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2014-11-21 : 08:56:02
maybe this is helpful:

http://www.sqlteam.com/tag/sql-server-indexes



Too old to Rock'n'Roll too young to die.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-11-24 : 01:46:25
@rajnidas - Run the query in ssms and capture the execution plan. This will giv you detailed information about what indexes (or table scans ) are occuring.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

akibintel
Starting Member

7 Posts

Posted - 2014-11-26 : 00:02:23
Hi rajni

First of all set indexes on columns of query which u r using in where clause .it makes difference



Thanks & Regards
Go to Top of Page

rajnidas
Yak Posting Veteran

97 Posts

Posted - 2014-11-26 : 01:24:37
Thanks to all

i tried following query its works fast

First of all set indexes on columns of query which u r using in where clause .it makes difference


Thanks & Regards

Rajnidas



Go to Top of Page
   

- Advertisement -