by sprachspiel on 5/5/10, 5:13 PM with 4 comments
by btilly on 5/5/10, 8:19 PM
If you're doing reporting then you really care about analytic queries. That is in 8.4. But the truth is that most developers don't use their databases in ways where they will benefit. However if you run across cases where you think, "I wish I could just suck this data out, sort it this way, then do this simple processing/grouping and upload that back into the database" then you have probably run across a use case for analytic queries. With analytic queries the only cases where I've had to do that are to join data that is not in the database, to process datasets that were too big for the database server to physically handle, and once because performance really, really required it.
by volomike on 5/6/10, 6:14 AM