|
|
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.
Navigation:
[Reply to this message]
|