Which is Better?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Cantley - 22 Mar 2007 15:09 GMT

Which is better to index. A view that pulls in all the fields I need and
indexing the view or indexing the tables I need and then merge the indexes.
I am looking for performance here. I have about 6 different tables that I am
joining in the view and only gettting the fields I need.

Thanks,
jc

Reply to this Message

Hilary Cotter - 22 Mar 2007 17:46 GMT

Under SP2 the view should be a better option. In prior versions you should
build a composite table for such a query.

Signature

Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Which is better to index. A view that pulls in all the fields I need and
> indexing the view or indexing the tables I need and then merge the
[quoted text clipped - 3 lines]
> Thanks,
> jc

Reply to this Message