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
 over indexed?

Author  Topic 

gongxia649
So Suave

344 Posts

Posted - 2008-04-24 : 12:13:54
what do u think about a table that has 19 indexes and some of them are covering index?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-24 : 12:17:32
Whats the table mostly used for? Is it a OLTP table or OLAP table? Is it for some reporting purpose?
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-24 : 12:18:16
Learn to index with

www.sql-server-performance.com.(they have lots of articles for it)
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-24 : 12:44:31
Why aren't you using your funketekun userid?

As a moderator here I can view certain information, so I know gongxia649 == funketekun.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -