(Craig Shallahamer) Suppose you want to check if a specific Oracle block is an index root block. Why? Here are two very real situations. You notice a specific block is very active and want to know if it’s an index root block.
Other News
Download DB2 Express-C 9.7.5, now with Oracle compatibility
The free IBM DB2 Express-C database now includes the same Oracle compatibility features as IBM’s enterprise databases. These features include support for PL/SQL, CLP+, data types, syntax, and much more.
Oracle SQL Tuning Example
(Michael McLaughlin) Somebody wanted a post on SQL statement tuning, so here it is. SQL statement tuning requires that you understand table definitions, constraints, and indexes plus how they interact through joins before you can begin tuning. Oracle presents some of the most advanced tools for tuni
ADF Faces – a logic bomb in the order of bean instantiations
(Chris Muir) One of my talented colleagues discovered an interesting ADF logic bomb which I thought I’d share here. The issue is with the instantiation order of ADF Faces scoped beans in JDev 11g when using Bounded Task Flows embedded as regions in another page.
Using MySQL with PHP mysqli: Connections, Options, Pooling
(Ulf Wendel) Opening a database connection is a boring tasks. But do you know how defaults are determined, if values are omitted? Or, did you know there are two flavours of persistent connections in mysqli?
Solving the Events-In-Progress Problem in DAX V2.0
(Chris Webb) This is probably the 5th or 6th post I’ve written on this problem (most deal with MDX, but I did blog about solving it in DAX early last year) but what can I say – it’s an interesting problem! I came across it at work today while working with the 2012 CTP3 version of PowerPivot and foun
Some new function, a new DSNZPARM keyword for index based partitioning conversion, and a ZPARM fix
(Willie Favero) There is a correction in DB2 9 and DB2 10 to how DB2 automatically converts from index based partitioning to table based partitioning using the system parameter IX_TB_PART_CONV_EXCLUDE (introduced by APAR PM45829, see below). The system parameter controls whether all columns are us
Selection Revisited
(Jim Mischel) In Selecting the Top N Items from a Group, I showed how to use a binary heap to efficiently identify the N largest items from a large collection. Using a binary heap is much faster than the naive method, but it’s not the only way to do it and not necessarily the fastest, either.
SQL Server – Administration – Cleanup Database Backup History
(Nakul Vachhrajani) Earlier this week, I had explored why the sequence of index creation is important in a rather long post on performance tuning. You can read the post here: SQL Server – Performance – Best Practice – Create Index Before or After a data insert?
Using Team Foundation Server 2010 Version Control for a Java Project
(Subodh Sohoni) In this article I am going to walk you through the entire process of how to use TFS 2010 for version control of a typical Java project. I will use Team Explorer Everywhere 2010 that is a plug-in to Eclipse and facilitates access to TFS 2010. It can be downloaded from here.