Correct Peter. "Rushmore can use any open indexes except for filtered and UNIQUE indexes."
http://msdn.microsoft.com/en-us/library/aa975907%28VS.71%29.aspx Unique indexes should be built, used, and then deleted because they are not maintained dynamically like other indexes. Peter jogged my memory. This bit me bad one time. --- On Thu, 9/24/09, Peter Cushing <[email protected]> wrote: > From: Peter Cushing <[email protected]> > Subject: Re: Why no Rushmore ? > To: [email protected] > Date: Thursday, September 24, 2009, 5:25 AM > Alan Bourke wrote: > > Given a table STRAN with a unique non-filtered index > on numeric field > > 'id' why would the following be unoptimised according > to sys(3054) ? > > > > Update stran ; > > set stran.st_pgimailed = > Iif(curTransactions.st_pgiticked, ldTime, > > {/}) ; > > where stran.id = lnID > > > > > > Note:Removing the IIF() and replacing with a discrete > date makes no > > difference. > > > Not sure if the unique bit has anything to do with > it. Have you tried > adding another index (not unique) to it to see if it will > optimise > then. Can't find anything in the help saying unique > is not optimisable > but it's worth trying. > > Peter > > ---------------------------------------------------------------- > > > > Rajan Imports has changed - we are now Whispering Smith > Ltd. For more information see our website at > www.whisperingsmith.com > > > Please update your address book with my new email address: > [email protected] > > . > > This communication is intended for the person or > organisation to whom it is addressed. The contents are > confidential and may be protected in law. Unauthorised > use, copying or > disclosure of any of it may be unlawful. If you have > received this message in error, please notify us immediately > by telephone or email. > > www.whisperingsmith.com > > Whispering Smith Ltd > Head Office:61 Great Ducie Street, Manchester M3 1RR. > Tel:0161 831 3700 Fax:0161 831 3715 > London Office:17-19 Foley Street, London W1W 6DW > Tel:0207 299 7960 > > > > _______________________________________________ > Post Messages to: [email protected] > Subscription Maintenance: http://leafe.com/mailman/listinfo/profox > OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech > Searchable Archive: http://leafe.com/archives/search/profox > This message: > http://leafe.com/archives/byMID/profox/[email protected] > ** All postings, unless explicitly stated otherwise, are > the opinions of the author, and do not constitute legal or > medical advice. This statement is added to the messages for > those lawyers who are too stupid to see the obvious. > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
