Re:Codd's relational vision – has NoSQL come full circle?
by lukaseder on Sunday December 15, 2013 @01:14AM
(#6908571)
I agree that automatic creation of indexes looks like a reasonable thing to do for a database like Oracle. Oracle could gather statistics and auto-create indexes where it seems fit, i.e. where there is a lot of querying and little writing going on.
In a way, this is what caches can do. Besides that, Oracle is already very good at giving you statistics and tuning hints to help you assess where you could add an index:
http://stackoverflow.com/a/2937047/521799
DB2 and SQL Server probably have similar tools. As far as I know, they all don't go as far as automatically creating or dropping any indexes.
Re:Codd's relational vision – has NoSQL come full circle?
by pepijndevos on Sunday December 15, 2013 @05:20AM
(#6908945)
Googles appengine datastore will suggest indexes, but it's rather bad at it IMO.
But yes, generally speaking, I'm also surprised to see that in 2013 we're creating our indexes manually. While there are of course applications where you really want to ensure that all the right indexes are created ahead of time, for most applications having indexes created automatically based on query patterns would seem like a much better solution.