Hi Mark,
You are right. If you create an index on ABC, and search on BC, the
query will not use an index.
If you search on A, AB or ABC, you query may use the index.
The 3 indexes you create are not redundant, but I would not do so. I
would reverse the order of your first index (Assigned Person, Assigned
Group, Status). This way you do not need to create the index 3.
You must always remember that you can search on fields in the order
they are defined in the index.
Jean-Louis Halleux
www.arsmarts.com
On 17 Sep 2009, at 17:30, Brittain, Mark wrote:
**
Good morning,
I think I inherited a mess and need some help with indexing. If I
have an index
Status
Assigned Group
Assigned Person
And the query is Assigned Group and Assigned Person does the index
get ignored because Status was not used?
What if I have similar indexes like these
Index 1
Status
Assigned Group
Assigned Person
Index 2
Assigned Group
Index 3
Assigned Person
Are these redundant?
Also is there and good information out there that really gets into
the nuts and bolts of indexing?
Thanks
Mark
____________________________________________
Mark Brittain
Remedy Developer
NaviSite
[email protected]
(315) 453-2912 x5418 (Phone)
(315) 317.2897 (Cell)
Reduce Cost of IT with Managed Hosting and Application Services from
NaviSite.
Visit www.NaviSite.com Today.
________________________________
This e-mail is the property of NaviSite, Inc. It is intended only
for the person or entity to which it is addressed and may contain
information that is privileged, confidential, or otherwise protected
from disclosure. Distribution or copying of this e-mail, or the
information contained herein, to anyone other than the intended
recipient is prohibited.
_Platinum Sponsor: [email protected] ARSlist: "Where the
Answers Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
