Wojtek wrote:
----- Original Message ----- From: "Vadim Gritsenko" <[EMAIL PROTECTED]>
No; more like ... -p [EMAIL PROTECTED] , so you will be able to find any user
by his login quickly.
Sorry, I'd made a mistake. I thought about pattern: ...-p [EMAIL PROTECTED]/url
maybe ...-p [EMAIL PROTECTED]/url is correct? I am afraid I expect too much :)
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.
Vadim