Home > Archive > MS SQL Server > April 2006 > Re: SQL 2000 Query Optimisation









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: SQL 2000 Query Optimisation
Doug

2006-04-06, 8:23 pm

a 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.

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com