October 19, 2017 at 5:09 am
Hi
can anyone tell me if elastic queries in Azure have access to the stats of the remote tables and if they'll use available indexes on those tables.
Are the execution plans for elastic queries any good?
Cheers
Alex
October 27, 2017 at 10:15 am
The execution plans are neither good or bad, they just are. They resolve as needed to make the query work.
Yes, the query, when correctly written of course, will use the indexes on the tables. You are going to have to think about how you structure the queries. Remember, the data has to be returned in order to do a JOIN and other stuff like that. JOIN criteria probably won't pass between databases therefore it won't perform well.
Test the heck out of your scenario to be sure.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply