Elastic queries performance

  • 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

  • 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