Posted by Erland Sommarskog on 11/04/07 17:24

Analizer1 (vettes_n_jets@yahoo.com) writes:
> thanks for the insult...but i asked for some help..
> on the best way to build indexes and query based on
> columns in the table...that are not key columns

And I asked for more information so that I would be able to give you
the help.

And, insult or not, it does help if you want people to help that you
express yourself clearly, and also stick to normal writing rules.
Many problems related to databases (and programming general) are
complex. But the people who read your question have little of no
knowledge of the business domain you are working with. Therefore it
is essential that you express your questions clearly so that outsiders
can understand.

Yes, I could make a guess of what you might need, but that would be
just a guess, and it may not be applicable at all. And I don't really
feel comfortable with spending time on writing bad guesses.

I repeat from my previous post.

>> Anyway, a standard recommendation is that you include:
>> o CREATE TABLE statment(s) for your table(s).
>> o INSERT statements with sample data.
>> o The desired result given the sample.




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]