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

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

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116436) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_