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.
89 freelance font une offre moyenne de $34/heure pour ce travail
Hi, I'm expert in sql server and have performed lot of query optimization . I can work on this project , please message me to discuss further. thanks
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.