Posted by Zamdrist on 03/30/07 13:53

On Mar 30, 6:11 am, othell...@yahoo.com wrote:
>
> You might consider creating a new clustered index on a column that is
> frequently used to join with other tables. Copy paste your code to QA
> and run a showplan with no exec, on and find out if it is doing a
> table scan or index search.

There is an index already on each of the two tables in question, one
each on the primary key only, and it is clustered.

When I run my own query with Show Execution Plan on, I see that there
are several Clustered Index Scans, Index Scans & Parallelism/
Repartition operations.

But this is my code, running in QA. I have no control over how the
application accesses the data.

[Back to original message]