3 ms·
I agree with you. There's a lot of hype around these nosql databases, because a lot of people simply don't understand sql databases or how to make them perform
by pj 17y ago
I agree with you. There's a lot of hype around these nosql databases, because a lot of people simply don't understand sql databases or how to make them performant or they haven't run into the problems RDBMSs solve yet.
I would like to add one quick correction or maybe clarification to, [Indexes] merely order the data in a certain way that makes it easy to pluck out certain rows since you don't have to look at every value.
Indexes don't always order the data, only clustered indexes order the data and there can only be one clustered index on a table. You can have lots of unclustered indexes that are merely pointers to data within the larger table.
http://en.wikipedia.org/wiki/Index_(database)#Clustered http://en.wikipedia.org/wiki/Index_(database)#Clustered