|
|
Posted by sql_server_user on 10/02/23 11:47
I reclustered the table and the query is of course much faster now. I
need to keep both versions of the table around for a while to see how
they compare for all the queries we run, so I have an insert trigger
keeping them in sync. I tried the other permutations of the query you
suggested, Erland, and they had no effect on the execution plan or
performance.
Thanks,
Seth
Navigation:
[Reply to this message]
|