Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.
If you are using DB2 V7 or higher, consider using scrollable cursors. With scrollable cursors, you can move directly to the rows you want without having to FETCH every other row returned by the cursor.
If a column “value” can be null, it can mean one of two things: the attribute is not applicable for certain occurrences of the entity, or the attribute applies to all entity occurrences, but the information may not always be known.
First of all, before I go any further, let’s first define what I mean by a “black box.” If I plan to recommend that you prohibit them we better both understand what it is we are talking about prescribing.
Database performance problems are not caused by magic. Indeed, all performance problems are always caused by change.