Wojtek wrote:
----- Original Message ----- From: "Vadim Gritsenko" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, March 31, 2004 11:02 PM
Subject: Re: Index pattern
You don't need "url" part - except the case when you have lots of users with same username but only some of them have "url'. In this artificial example, you would create two indexes: first index on "[EMAIL PROTECTED]", so you can find users by login quickly, and second on "url" element, to filter out users who do not have url element. Hope you got the point - you can have an index for each predicate you want to speed up.So I should use two indexes: -p [EMAIL PROTECTED]
-p url
I hope I got the point. Thanks for help.
If you have url element always (for all users) - you don't need this second index.
If you have only one user per login (and for query example you gave before) - you also do not need this second index.
In some other circumstances, you might need multiple indexes.
Vadim
