On Sat, Sep 6, 2008 at 3:24 PM, NickC <[EMAIL PROTECTED]> wrote: > >> Do you have a tag on DELETED()? > > No, only index is on OrdNo Ascending. >
Well, try the DELETED() tag and see what happens. When SET DELETED is ON, SQL SELECTs are designed to return only non-deleted records. It can use the index to determine which records are in the result set, but then it must retrieve every row to determine if it is deleted or not. It is usually far more efficient to just read a DELETED() index than 100,000+ rows of data, especially if they are wide. > I have now established that with fifty fields it is ok and takes less than a > second but with sixty fields it takes around a minute. So, size matters? What a surprise. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ 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.
