Oracle Database 11gR2 Performance Tuning Cookbook by unknow

Author:unknow
Language: eng
Format: epub
Publisher: Packt Publishing

Some developers overuse the DISTINCT keyword to ensure a unique set of results. We can avoid this situation by using the correct JOINS operations and FOREIGN KEY constraints, resulting in an optimal execution plan.

See also

See Chapter 3, Optimizing Storage Structures for recipes on indexing

Full Table Scan operation was explained in Chapter 4, Optimizing SQL Code in the Avoiding Full Table Scans recipe

Writing top n queries and ranking

One common problem when developing database applications is to show the first n rows of a set, ordering the data in a specific manner. For example, if we want to see the last 10 articles submitted in a web application.

In this recipe, we will see how to obtain this scope and how to obtain it faster.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.