Sounds like something peculiar to Oracle. I know in MySQL if a query breaks the DB, then you have bigger problems and the solutions are therefore far more wide-reaching and effective.
Wade.
Wade.
How much impact should automatic query plan optimization have?
- (drook)
- (9)
- Dec. 5, 2016, 05:14:41 PM EST
Realistic volume, perhaps?
- (scoenye)
- Dec. 6, 2016, 06:42:11 PM EST
You should automatically collect stats on an ongoing basis
- (crazy)
- (6)
- Dec. 6, 2016, 07:07:31 PM EST
One-off event
- (drook)
- (5)
- Dec. 6, 2016, 07:25:03 PM EST
Isn't that "one off" stuff...
- (Another Scott)
- Dec. 6, 2016, 08:11:35 PM EST
Huh?
- (crazy)
- (3)
- Dec. 6, 2016, 08:49:20 PM EST
What I mean is we'll keep having one-off events
- (drook)
- (2)
- Dec. 6, 2016, 09:45:02 PM EST
Absolutely not
- (crazy)
- (1)
- Dec. 7, 2016, 11:30:55 AM EST
This.
- (malraux)
- Dec. 13, 2016, 09:07:05 AM EST
I've not worked with a DB that needed that to happen.
- (static)
- Dec. 7, 2016, 12:50:35 AM EST