indexes

Question

indexes

dastagirid

SSCommitted

Points: 1810
More actions
June 22, 2009 at 6:33 am

#133427

hi...
I need to increase my database performance by using
indexes but i dont know how to use multi join querie procedures...
if help me to improve my query perfomance...It may help lot.
Regards & Thaks
Giri.D
Thanks
Dastagiri.D

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Not enough information.

If you want advice on indexing a query, please post at minimum the query, the table definitions and current index definitions as well as the execution plan for the query.

Please take a look at this article: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

dastagirid SSCommitted Points: 1810 More actions · Answer 2

hi..

I have 3 tables

table names :A,B,C

A table have columns :

A1 ,A2,A3

B table have columns like:

B1,B2,B3

C table have columns like:

C1,C2,C3

My procedure like this..

select A.A2,A.A3,B.B2,B.B3,C.C2,C.C3 from A inner join B on A.A1=B.B1 inner join on B.B1=C.C1

how can I apply indexes and increase performance of my queries......

Thanks

Giri.D

Thanks
Dastagiri.D

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Look at the joins. There's only one column from each table referenced in the joins. Hence to start with, create an index on each column that's referenced in the join clause.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass