Indexes question

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Indexes question

Indexes question

Rate Topic

Display Mode

Topic Options

Author

Message

sunny.tjk

Posted Wednesday, September 12, 2012 1:56 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, June 13, 2013 11:11 AM
Points: 267, Visits: 892

Is it ok to apply indexes on all the columns involved in the WHERE clause of queries? Our database is a read-only VLDB database.

Post #1358198

sunny.tjk

Posted Wednesday, September 12, 2012 3:24 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, June 13, 2013 11:11 AM
Points: 267, Visits: 892

Other than the space needed by these indexes, I'm not assuming there will be any bad repercussions by adding them because there are no updates/deletes/inserts into this database.
I'd really appreciate all the experts' advices.

Post #1358234

GilaMonster

Posted Wednesday, September 12, 2012 3:45 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:37 PM
Points: 38,028, Visits: 30,334

If you mean putting single column indexes on every column, probably not.

http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1358240

opc.three

Posted Wednesday, September 19, 2012 2:44 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 8:44 PM
Points: 6,826, Visits: 11,948

If your table is truly static and you have the space then add as many indexes as you need to cover the queries being issued. Go ahead and use a FILL_FACTOR of 100 (or 0) too. Another thing you can do to help performance is to move the table and its indexes to a new FILEGROUP and then mark the FILEGROUP as read-only.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1361627

« Prev Topic | Next Topic »

Permissions