Sfrgttk

Fundamental Solution of the Pell Equation

Amount of permutations on an NxNxN Rubik's Cube

Quick way to create a symlink?

Why didn't Eitri join the fight?

Do square wave exist?

Compare a given version number in the form major.minor.build.patch and see if one is less than the other

What is the escape velocity of a neutron particle (not neutron star)

Can anything be seen from the center of the Boötes void? How dark would it be?

Using et al. for a last / senior author rather than for a first author

Is it common practice to audition new musicians 1-2-1 before rehearsing with the entire band?

Do jazz musicians improvise on the parent scale in addition to the chord-scales?

How to show element name in portuguese using elements package?

Around usage results

Irreducible of finite Krull dimension implies quasi-compact?

Wu formula for manifolds with boundary

What does the "x" in "x86" represent?

How to react to hostile behavior from a senior developer?

Find the length x such that the two distances in the triangle are the same

First console to have temporary backward compatibility

What do you call the main part of a joke?

Is there such thing as an Availability Group failover trigger?

Why do we bend a book to keep it straight?

Why are both D and D# fitting into my E minor key?

How to answer "Have you ever been terminated?"

Azure SQL Server - big query choosing bad execution plan

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

I'm using Azure SQL Server v12 and I have big, complex query that runs ok but when I add more joins, it doesn't matter which table I'm joining to, it gets super slow. The important thing to point out is that by adding a simple join it's choosing a different execution for the whole query and I receive warning on sort operations that are not performed in the original query.

I cannot post the query or the execution plan but I want to know if someone faced a similar case. My intuition tells me that SQL Server is choosing a bad execution plan because the query is so big that it times out when it tries to pick one.

Should I indicate the join type and index name for each join to keep the original execution plan? is that the best way to go?

query-performance execution-plan azure-sql-database

share

asked 3 mins ago

Francisco GoldensteinFrancisco Goldenstein

1412

add a comment | 

0

I'm using Azure SQL Server v12 and I have big, complex query that runs ok but when I add more joins, it doesn't matter which table I'm joining to, it gets super slow. The important thing to point out is that by adding a simple join it's choosing a different execution for the whole query and I receive warning on sort operations that are not performed in the original query.

I cannot post the query or the execution plan but I want to know if someone faced a similar case. My intuition tells me that SQL Server is choosing a bad execution plan because the query is so big that it times out when it tries to pick one.

Should I indicate the join type and index name for each join to keep the original execution plan? is that the best way to go?

query-performance execution-plan azure-sql-database

share

asked 3 mins ago

Francisco GoldensteinFrancisco Goldenstein

1412

add a comment | 

I'm using Azure SQL Server v12 and I have big, complex query that runs ok but when I add more joins, it doesn't matter which table I'm joining to, it gets super slow. The important thing to point out is that by adding a simple join it's choosing a different execution for the whole query and I receive warning on sort operations that are not performed in the original query.

I cannot post the query or the execution plan but I want to know if someone faced a similar case. My intuition tells me that SQL Server is choosing a bad execution plan because the query is so big that it times out when it tries to pick one.

Should I indicate the join type and index name for each join to keep the original execution plan? is that the best way to go?

query-performance execution-plan azure-sql-database

share

asked 3 mins ago

Francisco GoldensteinFrancisco Goldenstein

1412

share

asked 3 mins ago

Francisco GoldensteinFrancisco Goldenstein

1412

share

asked 3 mins ago

Francisco GoldensteinFrancisco Goldenstein

1412

asked 3 mins ago

Francisco GoldensteinFrancisco Goldenstein

1412

asked 3 mins ago

Francisco GoldensteinFrancisco Goldenstein

1412