Skip to content

Tag: database-performance

Select distinct very slow

I have a table where I store rows with external ids. Quite often I need to select latest timestamp for given external ids. Now it is a bottleneck for my app Query: Explain: What could I do to make this query faster? Or probably should I use completely different query? UPDATE: Added new query plan as asked @ja…

MS ACCESS SQL Join Subquery

I have two tables: newparts, storedparts I insert the parts of the newparts, which are not jet in the storedparts into the storedparts: This is working fine so far. Now the Problem: Table storedparts is getting so big that the programm is taking too Long for the join process. My solution: Just compare the new…