In my scenario, I am not searching for a particular name. My query is
to list all names inserted in a specific week. if I split my 10
million names based on time-range, i.e., one table per week, then I
only need to search 1~2 tables with much smaller amount of data.




--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:

>
> Now, imagine I have a phonebook with 10 million names, searching for
> a specific name becomes slower.
>
> Now, imagine I have 1 million phonebooks with 10 names each. Why does
> this make searching for a specific name faster?
>