Daily Roundup of News, Tips and Tricks for 2010-02-03

10 best IT jobs right now

IT professionals looking to find new employment or upgrade their current positions should investigate job opportunities that address growing demand for technologies such as virtualization, cloud, network security and social computing skills.
Goodbye, blogs.sun.com

Now that Sun has become a wholly owned subsidiary of Oracle, it appears that there will be some changes to the way Sun bloggers operate.
Why isn't the index used for this query?

It's the NOT NULL constraint because NULL values are not included in a normal B-TREE index, but the GROUP BY has to include NULL as a grouping "value" in your query. By telling the optimizer that there are no NULLs in col it is free to use the much more efficient index . This is a classic example of how metadata can influence the optimizer.
The database for the cloud age: FathomDB [Video]

Almost every company uses a database as the driving force behind their Web site. FathomDB administers a relational database on the cloud for customers and absorbs the responsibility of maintaining a database server.
SQL_TRACE is deprecated

SQL_TRACE parameter is no longer valid – it is deprecated as of Oracle 10g Release 2 in favour of DBMS_MONITOR subprograms.
Improving performance with pipelined table functions

Examples of typical data-processing requirements and how you might tune them with pipelined functions.

Filed in Links on 03 Feb 10

Comments are closed.