Yes OOB 2 indexes are present. Regarding search is slow can you please check API as well as SQL logs. [cid:[email protected]]
The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Drew Shuller Sent: 11 February 2013 10:44 To: [email protected] Subject: Email Messages Form Indexes? ** 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 _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
<<inline: image001.png>>
