On that note, what's your take on $ORCL's "autonomous database" that they've been marketing over the last couple of years? I saw the Ellison presentation on it when it was first announced and it seems plausible you could tune databases on-the-fly and maybe optimize indices "automatically", given your comment I was curious what you think about this specific offering.
Is it really anything new? Informix was self tuning in the 80s.
I suppose you could automatically identify slow queries and identify what indexes would be useful, sort of how a JIT identifies hotspots in code and optimises them.
Personally it sounds like a play to keep lucrative enterprise customers on side by allowing them to cut the DBA role that is a necessity for a decent sized Oracle install.
https://www.oracle.com/database/what-is-autonomous-database....