index - SQL Server Forums

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.

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

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

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources