Tech
I see no need to split the table. If you properly index the table you should be fine. In fact, splitting would only complicate things. Every query would have to do a union on the 2 tables and that would just slow up the processing.
What is the purpose of this table? are you using it to import data from another source?
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
--- In MS_Access_Professionals@yahoogroups.com, "Tech Learner " <tech_learner@...> wrote:
>
> Hi All,
>
> I have an access table 'data_all'. This table have more than 200000 records. I need to split this data in tables of having 10000 records. Number of records in the data_all table will keep on increasing MoM.
>
> I wish to know the best way to split this table in access
>
> Many thanks,
> TL
> Sent from BlackBerry® on Airtel
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar