Dba: Why is SQL doing an index scan and seek with the same XML query structure?

Channel:
Peter Schneider
Subscribers:
4,110
Published on ● Video Link: https://www.youtube.com/watch?v=elXfO-PxT00


Duration: 0:00
1 views
1

Why is SQL doing an index scan and seek with the same XML query structure?
I hope you found a solution that worked for you :)
The Content is licensed under (https://meta.stackexchange.com/help/licensing) CC BY-SA.
Attention! This video does always use the same license as the source!
Thanks to all those great people for their contributions!

(dba.stackexchange.com/users/149940/middletone)Middletone
(dba.stackexchange.com/users/2103/mikael-eriksson)Mikael Eriksson
(dba.stackexchange.com/users/1192/paul-white)Paul White
A special thanks goes out to the (dba.stackexchange.com/questions/288872/why-is-sql-doing-an-index-scan-and-seek-with-the-same-xml-query-structure)Stackexchange community

I wish you all a wonderful day! Stay safe :)
If anything is off, please write me at peter D.O.T schneider A.T ois42.de

xml sql-server index-tuning t-sql performance



Other Videos By Peter Schneider


2025-03-16Gis: QGIS - copy features with multiple attributes
2025-03-16Drupal: Uploading from within fieldset using drupal 6 forms API not working
2025-03-16Mathematica: Exanding expressions inside square root closed
2025-03-16Mathematica: How to introduce an action between sets and an recursive relation?
2025-03-16Electronics: 134.2 kHz RFID reader for Arduino
2025-03-16Electronics: Flip-Flop resets when motor starts
2025-03-16How to list a 2d array in a tabular form along with two 1d arrays from which it was generated?
2025-03-16Drupal: Performance using location based information and proximity filters
2025-03-16Electronics: Noise Model for Zener Diodes
2025-03-16Dba: Syntax error only on one specific server
2025-03-15Dba: Why is SQL doing an index scan and seek with the same XML query structure?
2025-03-14How do you cast a potentially readonly key to readwrite key in TypeScript?
2025-03-14Apple: How to re-enable Touch ID password autofill when Mac disables it
2025-03-14Apple: Unable to map keyboard like I could in previous macOS versions ...?
2025-03-14Bitcoin: How to find BitStamp's Ripple address? closed
2025-03-14Bitcoin: Bitcoin Address Wiki Issue
2025-03-14Arduino: Water flow sensor unable to get readings
2025-03-14Codereview: Writing lists to .csv file
2025-03-14Bitcoin: How long does it take for an exchange to send me bitcoins?
2025-03-14Codereview: Number guessing game in Racket
2025-03-14c++ std::stof() throws out_of_range for 5.87747175e-39