2013 | OriginalPaper | Buchkapitel
8. Analytic Functions
verfasst von : Karen Morton, Kerry Osborne, Robyn Sands, Riyaj Shamsudeen, Jared Still
Erschienen in: Pro Oracle SQL
Verlag: Apress
Aktivieren Sie unsere intelligente Suche um passende Fachinhalte oder Patente zu finden.
Wählen Sie Textabschnitte aus um mit Künstlicher Intelligenz passenden Patente zu finden. powered by
Markieren Sie Textabschnitte, um KI-gestützt weitere passende Inhalte zu finden. powered by
Abstract
http://www.oracle.com/technetwork/indexes/documentation/index.html
), they are often thought useful only in data warehousing SQL. In the previous chapter, we examined how advanced grouping techniques can be used to accomplish so much that you may be wondering why you need to bother with analytic functions. Well, just like really good carpenters have numerous tools in their toolbox, so should we make sure our developer toolbox is filled with many different tools to help us write good SQL. If we limit ourselves to only a couple tools, we're bound to use constructs every now and then that are less performance friendly than others.