3 ms·
Doesn't the last part of the article, proposing a system to selectively adjust cost calculations, acknowledge the existence of people like you?
by brlewis 16y ago
Doesn't the last part of the article, proposing a system to selectively adjust cost calculations, acknowledge the existence of people like you?
- btilly 16y agoNo. Because in my particular situation I did not have DBA access, and I was running queries against a restored backup of an OLTP system. The risk/reward is such that it made absolutely no sense to try to tweak things to make my queries run faster at the potential cost of doing who knows what damage to the queries that were running in the OLTP system. Therefore, even if I was still in that reporting role, I would never, ever even CONSIDER playing with the knob they gave me. And even were I so reckless, no sane DBA should allow it.
- brlewis 16y agoThis snippet from the article makes me think their proposal only affects one query at a time: For example, one which allowed you to put "SELECTIVITY 0.1" after a WHERE clause
- btilly 16y agoOops, you're right. Let me see. I can peer inside of a running black box and twiddle knobs that do something I don't understand until I magically get the right result. Then I can cross my fingers and hope it doesn't change out from under me. Why does this not sound appealing?