Running DQD on a large SQL Server database (resources on what indexes to create)

Hi!

We have a relatively large OMOPed database running on SQL Server. The R script would not successfully complete, so we’ve had to run the DQD sql scripts more manually (I believe this may be an issue with timing out and then require re-authentication via Entra-ID?).

Are there any resources for indexes we can apply that are most impactful? I could try do this myself, but would love if someone has already gone through the pain of creating a set of these!