Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
Re: SQL 2000 Query Optimisationa few thoughts. verify there is a composite index created on portfolioid,snapshot id in validreportingprimar ykey try creating a non-clustered index on basedata.portfolioid after you have inserted the data. there is more to this story, or you wouldn't be needing validreportingprimar ykey twice.
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
