Quoting Steve Haslam (steve@???):
> SELECT destination FROM user_aliases
> WHERE localpart IN ('$local_part', '%') AND domain = '$domain'
> AND rownum <= 1
Yeah! Later I thought of the possibility of sub-selects.
But I received more efficient queries :)
> which does two unique scans rather than a range scan. If you have enough
> entries to justify using an index at all, mind you :}
When the project succeeds we expect to have alot of entries, so indexes
are needed for sure ;) I'm interrested in the way exim will deal with
this. Configuration from databases, and high load email traffic...
Regards,
Sander.
--
| Love comes back to you <-=|=-> you to back comes Love
| 1024D/08CEC94D - 34B3 3314 B146 E13C 70C8 9BDB D463 7E41 08CE C94D
