Timeline for Inefficient queries on partitioned tables
Current License: CC BY-SA 3.0
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 29, 2015 at 8:59 | comment | added | Phil Stephenson | I have updated the original post with more context. That said, even given your points above I still fail to see how scanning a table, or index or using index seeks on table would be more efficient than on only the partitions required by the query, except in the case of a non-partition aligned index I will concede. | |
| May 29, 2015 at 8:37 | history | answered | David Spillett | CC BY-SA 3.0 |