When the table is small, the query is very fast. After it grows to
more than 10 million records, query becomes slower and slower. Since
I don't query all records but only a portion, I think splitting table
into smaller ones can help improve query speed?

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

>
> But what makes you think your query will be faster if your table
> data is split across more tables?
>
> Martijn Tonies