We use it for transient data caching and adhoc analysis. In combination with good indexing it's relatively fast for our queries.