Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement

More articles by Boris Milrud

Author Bio
Boris Milrud has more than 10 years of experience as a software developer. He is a Senior Database Engineer with Callidus Software, Inc. located in San Jose, CA. He specializes in all aspects of Oracle database software development, including database design, programming, optimization, and tuning.
For Database Development Zone | December 1, 2004
Perform the massive DELETE operation as a swap delete with parallel execution. This technique can offer significant performance gains over a straight or in-place delete operation.
For Database Development | October 18, 2004
By performing DELETEs as INSERTs, you can complete massive DELETE operations in your Oracle database without having to pay the heavy performance overhead.
For Database Development | July 21, 2004
The usual method for extracting DDL commands from objects (such as database tables, indexes, constraints, triggers, etc.) involves extracting the metadata from those objects and storing it in memory. While there are many scripts capable of doing this, they are usually incomplete and out-of-date. Luckily, Oracle 9.2 provides an API that does the trick: the DBMS_METADATA package.
For Database Development | April 30, 2004
If you need a solution for running Oracle stored procedures in parallel, don't reinvent the wheel with solutions that run outside the database. Execute stored procedures in parallel inside the database using Oracle's native APIs and PL/SQL.
For Database Development Zone | October 21, 2002
Today's enterprise-level applications usually work on multiple database platforms, which makes code portability and maintainability increasingly important. However, porting code from one database platform to another is complex and time-consuming because database vendors use their own proprietary procedural languages.
Sitemap