|
October, 2004
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||
|
||||||||||||||||
|
Skip Scan Index Access
In Oracle, releases before Oracle9i, the Cost Based Optimizer (CBO) would only use a composite index (sometimes referred to as a concatenated index) if you referenced the index prefix column in the WHERE clause of the SQL statement. If the SQL statement omitted the index prefix column of the composite index, the CBO would not use the index. One solution would be to simply create another index on the non-prefixed index columns in order for Oracle to use an index for faster access to the data. This method, however, may add considerable overhead when Oracle had to update several indexes during DML operations. A new feature included with Oracle9i called Skip Scan Index Access allows the Oracle CBO to use a composite index even when the index prefix column in a SQL statement has been omitted. Using this new feature, you will not have to create an additional index to provide faster access to your data. This article provides a brief introduction to Skip Scan Index Access and how it can improve the response time of your queries.
Click here
for the article. | ||||||||||||||||
|
||||||||||||||||
|
Best Practices for Tuning DB2 UDB v8.1 Performance is a vital key to the success of your on demand applications. When those applications are using IBM® DB2 Universal Database™ as a data store, it's essential that you begin with a fundamental knowledge of how to achieve the best possible performance with DB2 UDB. In this article I'll give in-depth recommendations for tuning a DB2 UDB V8 system. We'll talk about performance issues from the beginning to the end of the process. You can follow the flow from creating a new database to running with your application. You will see how to use the DB2 auto-configuration utilities to initially configure your database manager and database environment. Then I'll discuss best practices for creating buffer pools, table spaces, tables, and indexes. There are some important configuration parameters you may want to adjust from their initial settings to better support your application, so we'll take a look at those configuration parameters as well. Click here
for the excerpt. |
||||||||||||||||
|
||||||||||||||||
|
Self-Managing PL/SQL Oracle has introduced significant
management automation features in its flagship database product and has described
the new Oracle Database 10g release as "the self-managing database." Given that
achievement and direction, I thought it would make sense to talk about how to write
one's PL/SQL application so that it is also self-managing.
Click
here
for the article. |
||||||||||||||||
|
||||||||||||||||
|
First Impressions of SQL Server 2005: Installation and Tools This is the first part of a series of articles
where I take you through my exploration of SQL Server 2005 Beta 2. In this part of the series,
I’m going to cover what is SQL Server 2000’s strongest asset, its tools. The tools like
Enterprise Manager and Profiler give you the quickest way to get to the market with your product.
The tools in SQL Server 2005 have begun an evolution to where you will not recognize it as SQL
Server. This article provides a high-level overview of my first impressions of the tool suite and
the installation. Keep in mind that I’m only touching the surface and that this can cover several
articles. Click
here
for the article. Freeware: Toad for SQL Server & Toad for MySQL
Quest now offers freeware tools for MySQL and SQL
Server developers and database administrators. With the knowledge and success
gained from our past experience with TOAD® for Oracle, we’ve created
Toad® for MySQL – Preview Release and Toad® for SQL Server.
Developers and database administrators alike can use a familiar tool that improves
productivity by providing an easy-to-use development environment to manage MySQL and
SQL Server databases. As with TOAD, Quest equips you with the ability to create and
execute queries, automate database object management and create both SQL Code and
T-SQL code more efficiently with an intuitive graphical interface.
SQL in a Nutshell, 2nd Edition This essential desktop reference drills down and
documents every SQL command and how to use it in both commercial (Oracle, DB2,
and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL).
It includes the command syntax (by vendor, if the syntax differs across
implementations), a description, and practical examples. And it also explains how
the leading commercial and open sources database product implement SQL. This wealth
of information is packed into a succinct, comprehensive, and extraordinarily
easy-to-use format.
Click here for more information on the book, including an excerpt and preliminary feedback from readers.
|
||||||||||||||||
|
||||||||||||||||
An action item is work that requires follow-up execution. By their nature, action items normally cannot be planned for in advance. They arise on an ad-hoc basis during meetings or as a by-product of working on something else. An action item is assigned because there is not enough knowledge, expertise or time to resolve the item at the time. In many cases, action items are administrative in nature, but in other cases they can require substantial work to complete. Action items need to be assigned, worked on later and completed. (If they are not going to be completed, they should not be called action items. Instead, simply note that the item will not be followed up on.) Examples of action items include forwarding specific information to someone, arranging a meeting and providing a quick estimate on a piece of work. Click here
for more information on action items. | ||||||||||||||||
|
||||||||||||||||
|
Free Webcasts
| ||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
Interactive Crossword
Puzzle: "Candy"
|
||||||||||||||||
|
||||||||||||||||
|
We love getting white papers, tips, articles, and code examples/archives from our readers around the world. Send your submission to newsletter@quest-pipelines.com. If your article is published, it will be mailed to over 28,000 subscribers. Our mission at Quest Software - RevealNet Labs is to anticipate the daily responsibilities and challenges faced by database professionals. Our products help thousands of people solve problems and implement solutions every day. This newsletter is designed to help facilitate the sharing of information among database professionals. About the Newsletter This newsletter is distributed to Quest Software - RevealNet Labs customers, prospects and friends who have subscribed to it from our website. If you would like to unsubscribe, please visit http://qlist01.quest.com/UnsubMailingList/ Subscribe a Friend! Do you know someone who would like to receive the Pipeline Newsletter? If so, please enter their email address in the box below and click SUBMIT.
Past Issues of the Pipeline Newsletter |
||||||||||||||||
