Velikost videa: 1280 X 720853 X 480640 X 360
Zobrazit ovladače přehrávání
Automatické přehrávání
Přehrát
In your compound index slide you mention that the WHERE clause with a=@a and c=@c and b=@b may partially use the index. Why that happens since all the first three columns of the index a, b and c are referenced in the where clause?
Good read to understand the internal of composite indexes stackoverflow.com/questions/795031/how-do-composite-indexes-work
could you post the code you show in the video? thanks :)
The demo code is available in articles on sqlperformance.com which correspond to each demonstrated technique.
In your compound index slide you mention that the WHERE clause with a=@a and c=@c and b=@b may partially use the index. Why that happens since all the first three columns of the index a, b and c are referenced in the where clause?
Good read to understand the internal of composite indexes stackoverflow.com/questions/795031/how-do-composite-indexes-work
could you post the code you show in the video? thanks :)
The demo code is available in articles on sqlperformance.com which correspond to each demonstrated technique.