Posted by Jack Vamvas on 10/23/07 12:35

If you could post an example Query ?

--

Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com




"Enorme Vigenti" <LSimon5@libero.it> wrote in message
news:0kZSi.151009$U01.1108206@twister1.libero.it...
> Hi all,
> I have a very large table with many columns: dateTime type, nvarchar type
> and integer field type.
> A program exec many type of query with where clause.
> Data field is always in where clause, but some other field is present too.
> Sometimes integer field, sometimes nvarchar field.
> Now I must create index for the query!
> For choose index field what i can do?
> I must create only index on a datetime field or every combination in every
> type of query?
> In the second case I must create very much index! But this is very
> dispendious for update/insert/delete operation on the table!!!
> Some ideas?
> thnx

[Back to original message]