Re: [MSAccessProfessionals] Access Data Query long running - left join

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