The query is a straightforward inner join with a table that contains 71000000 records. It currently takes anywhere between 1 and 3 minutes to run.
91 pekerja bebas membida secara purata $34/jam untuk pekerjaan ini
Hi Did you try to add indexes on the joint columns? I can help to check it. I am a software engineer with 8 years' experience of .net developing. Please contact me for further discussion.
Hi, i have very good experience with sql query optimization. Please let me the table/index details and query criteria. Based on these details i should be able to quickly optimize your query.