I didn't think about the Report Builder angle. Thanks so much for the reply.

That's what I was struggling with. How unique does something need to be in order to be considered "selective"? I have SSN, dates, and some other data, but...

Any suggestions then on how I can increase the performance on this data? Should I just create a few single non-clustered indexes on often-used columns?

No problem. Yep, I did accidentally leave the Unique flag checked. I've decided I'm going to create an identity column to help with indexing.

I tried to create a clustered index on the view as seen below.

But I received the following error.

I just looked at the data to find some columns to create the clustered index and there aren't any combination of columns that are consistently unique in the entire table....

That's why I was wondering if I should index the view instead of the tables, because the data types in the tables aren't optimal for indexing. So, should I...

I will be linking to the view in MS Access and users will be writing queries against the view. They'll be doing some filtering and aggregating.

Thanks Drew, but it appears that the link you gave just points right back to this thread. I searched SSC for "quirky update" but didn't find any articles that...

Thanks for the reply. I find your example very interesting as I have never seen some of that functionality. I will definitely study it to see what I...

Thanks for the replies everyone. I've learned something new today. That alone makes it a good day. 🙂

Robert Dudley (5/21/2010)

---

traughberk (5/21/2010)

---

I have a question about LEFT JOIN example near the beginning where he starts talking about EXCEPT where he wrote the following SQL.

SELECT C.CustomerID

...

Never mind folks. I figured it out myself which is what I should have done in the first place. I guess I'm just lazy this morning. Sorry...

I have a question about LEFT JOIN example near the beginning where he starts talking about EXCEPT where he wrote the following SQL.

SELECT C.CustomerID

...

Thanks for both responses. We too have come up with our own algorithm that we are going to start testing to address the issue. But, I'm still going...