it's important that text fields you're joining on have a short Size. By default, text fields are 255. I change default to 50 but even that is too long for fields you'll use to join. When indexes are made, the full Size is used. You may not be able to change field Size of big tables. Best to do then is make a new table with proper sizes and append all the records.
What are the data types for fields you're joining on?
kind regards,
crystal
On 9/4/2023 4:41 AM, Kiran Kumar via groups.io wrote:
i am trying to resolve this in MS access only as we dont have access to use other DB
On Sunday, September 3, 2023 at 02:54:39 PM GMT-8, anzus101 <anzus101@gmail.com> wrote:
You best bet is to move your back end to postgresql, then create a view and then link the view as an external data source.
On Monday, September 4, 2023, Kiran Kumar via groups.io <kirankumarnv=yahoo.com@groups.io> wrote:
I am trying to fetch data from two tables of 0.7 M records Left Join match all 7 columns with 1.5 M records table and Group By all columns from left table.
Data Query is getting freezed and long running with no output. FYI i tried applying index
I am getting immediate output if i use aggregate functions with this join
Please advise at the earliest
Tidak ada komentar:
Posting Komentar