Guessing from the query, the MeldeDatum, VonDat  and number columns may
provide indexes that the optimizer can use to retrieve the desired data more
quickly. I don't see where you could use a full-text index, which is  a
special kind of index useful for columns that contain large amounts of text
data (like an email).

Whether or not an index on any of those three columns is useful will primary
be determined by what the distribution of data in the column looks like. In
other words, if the column has mostly one value in it, it makes for a poor
index choice. If the column has many different values (the best case being a
different value for each row), it makes for a good choice.

Hope This Helps,

Darin Strait, MS SQL Server Development and Administration
http://home.earthlink.net/~dstrait/professional/resume.htm


----- Original Message -----
From: <a9603897@u...>
To: "sql language" <sql_language@p...>
Sent: Friday, July 20, 2001 12:43 PM
Subject: [sql_language] RE: Improving my SQL-Server Query


> Hello,
>
> Thank you Ajit, Darin and Roger for your answers. I just want to answer my
> unclear definitions of my emails.
>
>
> By "hang", do you mean that the query fails with an error message or that
> it never seems to stop running? -> I mean, that it seems that the query
> never stops running(sorry for my bad english).
> I tried already running the query before I leave work and it ran about 12
> hours, but I still did not get any result.
>
> How large are your tables, in terms of the count of rows?
> the biggest table has about 40.000 rows the other tables(5 of them) have
> about 5000 rows.
>
> What do your indexes look like? I have no index on this table. I tried to
> create an index with the wizard, but the program is teling me, that the
> table has not unique column index and I cannot create a full-text index on
> the selected table
>
> Are there other users on the system when you are doing your queries? If
> they are updating data, they may  be blocking you.
> No, I am the only one who is using the database over the night.
>
> Do you have a hint, how I can index the tables properly, which column I
> should index to get the best result for thes query`?
>
> Thank you all for your great support(Ajit,Darin and Roger)
>
> Chris