Posted by Wes Groleau on 02/03/07 05:03

Erland Sommarskog wrote:
> Unforunately there is very little here to work from. X12 tells me
> nothing. And in any case you have added a number of indexes that are
> unknown to me. But let me point out thing: indexing single columns is
> far from always sufficient. Often you need composite indexes.
>
> To be able to say something more useful, I would be able to see
> the CREATE TABLE statements for the tables. (Or is there only one?),
> as well as the indexes, including keys. And of course I would need
> to know your UPDATE statements. And if there are any triggers, I
> need to see those as well.

No triggers. I tried to script the table (actually I tried to script
a similar table to save myself some typing) but the wizard saved no file
and gave no error message. So I copied the table and used the GUI to
strip out the fields I didn't need/add a few others

All the fields referenced in the UPDATE statements are indexed.

The update statements are almost identical--the difference is that in

UPDATE Output SET xyz = (SELECT Max(Seg_Nbr) FROM Raw_Segs
WHERE Output.FID = Raw_Segs AND Seg_Nbr BETWEEN abc and pqr)

xyz, abc, & pqr are different columns, such that pqr - abc is
a wider range in the one that works; narrower in the one that
dies with timeout.


--
Wes Groleau

A pessimist says the glass is half empty.

An optimist says the glass is half full.

An engineer says somebody made the glass
twice as big as it needed to be.

[Back to original message]