Good morning! Could anyone confirm what indexes are OOB on the Email Messages form?
AR Server 7.5 Patch 008, MS SQL 2008 DB The first index contains 7 colums: Mailbox ID, Message Type, Priority, Send Message, Parse Message, Message ID and Execute/Send at. Is this OOB? The second index is one field, the Unique Identifier. The third one I just created with one field, Create Date. There are 3500 records in that form and an unqualified search is taking over 30 seconds. A search on create-date >= $DATE$ takes only slightly less time. Drew Honduras _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
