mercredi 7 janvier 2015

Use of empty tables in Join in SQL server


If I use empty tables in a join, then will it impact query performance. if it affects the performance, then how much.


Also, will index creation make any impact?


As I can see the execution plan, the table is present there, but the cost is 0.


I cannot remove table from query due to maintain code consistency.


Thanks in advance for your suggestions.





Aucun commentaire:

Enregistrer un commentaire