What seems like ages ago, I listed 8 things you may not have known about indexes. Although I’ve since written about many of the 8 items, I’ve yet to address the last item listed:8. An index can potentially be the most efficient and effective may to
The proper use of the SQL optimizers can have a huge impact on the speed of SQL execution. Both the rule-based and cost-based optimizers have shortcomings, and it is up to you to tune each SQL query to use the proper optimizer. Rule-based
Pagination is the simplest and most common way to break up large amounts of data into more manageable chunks. Pagination is a key part of Web site design, both from the UI perspective (to manage limited screen real estate) and from the server
By Steven Feuerstein Best practices for knowing your LIMIT and kicking %NOTFOUNDI have started using BULK COLLECT whenever Ineed to fetch large volumes of data. This has caused me some troublewith my DBA, however. He is complaining that although my
These work good on 9i .free.sql-amount of freespace in a tablespaceselect tablespace_name, round(sum(bytes)/(1024*1024),0) MB from dba_free_space group by
Whenever a valid SQL statement is processed Oracle has to decide how to retrieve the necessary data. This decision can be made using one of two methods: Rule Based Optimizer (RBO) - This method is used if the server has no internal statistics
Mike Ault Tips - August 5th, 2004 PCTFREE and PCTUSEDThe PCTFREE and PCTUSED parameters tell Oracle when to link and unlink a block from the freelist chain. The following discussion only applies if you are not using the new Automatic Segment Space