Creating an index is pretty easy.

CREATE INDEX index_name

ON table_name (field_to_index)

Is this what you were looking for?

Caz

Heya... I would look further into your database design.

There are things called primary keys, with the way you have set this your table2 looks something like a lookup table which...

Craig wins it...

There is an issue in parsing upper and lower case and collation.

Regardless... sitting down with a database plan cures all!!

Caz

Yo,

With only that information you have given me I am gonna put money on the select DISTINCT is the issue - SQL normally works top to bottom hence the sequential...

I have a sideways solution to this.

I just made a heap of datasets, one for each piece of data I wanted to represent and then edited this query slightly each...