Timeline for Why select max partitioned column is much slower than indexed one?
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 14, 2012 at 18:05 | comment | added | JNK | @NickW it still needs to check the actual data. | |
| Feb 14, 2012 at 17:31 | comment | added | u23432534 | The table is huge and K1 has very low selectivity and it's partitioned. It seems SQL server engine should be able to figure out from the partition meta information? | |
| Feb 14, 2012 at 17:20 | history | answered | JNK | CC BY-SA 3.0 |