>
> It depends on what you're going to do. If the idea is to join across
> the tables, it'll probably perform worse than just ahving a large
> table. OTOH, if what you're doing is, say, archiving from time to
> time, it doesn't seem unreasonable.
>
The purpose for this design is to avoid record lookup in a huge table.
I expect to see the query results in, say, one minute, by searching a much
smaller table (not join across multiple tables).
Thanks and regards.
Li Li