Indexing Tables

[atiqraza]

Does anybody happen to have links to any tutorials about Indexing tables in sql. I seem to be working with huge tables greater then 1GB in size and have a couple of joins to do, and they seem to be taking quite a lot of time. I need to speed things up.
Thnx

 

[SQLDenis]

There is more to tables than just adding indexes
how wide is the table, the wider the table the more IO is needed to bring back the rows?
what is the fragmentation level of your table?
is your WHERE clause sargable?
Is your selectivity level high an index will be ignored if it is not
there is much more to tuning than just adding indexes

1 GB is not a huge table nowadays I have tables that are well over 10 and 20 GB in size

take a look at the indexes section here

http://www.sql-server-performance.com/tips_performance.asp

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/