<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.8" -->
<rss version="0.92">
<channel>
	<title>Database Experts</title>
	<link>http://www.dbpundit.com</link>
	<description>oracle &#124; mysql &#124; postgre &#124; mssql &#124; db2</description>
	<lastBuildDate>Thu, 17 Dec 2009 11:35:08 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>Oracle Performance Tuning Tactics Part 2: Using Indexes</title>
		<description><![CDATA[To recap, the &#8220;weapons&#8221; available in your &#8220;arsenal&#8221; for performance tuning are as follows:- Full table scans ; Indexes; Joins; Views; De-normalization; Oracle Stored Procedures; Sub-queries.
2. Indexes
There are several types of indexes available with Oracle databases:
* normal/B-Tree (balanced/ binary tree) indexes;
* bitmap indexes (which literally use a map of bits to represent the whole index [...]]]></description>
		<link>http://www.dbpundit.com/2009/12/oracle-performance-tuning-tactics-part-2-using-indexes/</link>
			</item>
	<item>
		<title>Oracle Performance Tuning Part 1: Using Full Table Scans</title>
		<description><![CDATA[It is a common misconception that all SQL queries on all tables in Oracle databases should be index driven. In fact, using full-table scans can improve performance in two scenarios: when querying very small tables and when querying very large tables.
The Effect of Full Table Scans When Querying Small Tables
Let&#8217;s suppose your using your Oracle [...]]]></description>
		<link>http://www.dbpundit.com/2009/12/oracle-performance-tuning-part-1-using-full-table-scans/</link>
			</item>
	<item>
		<title>Oracle Performance Tuning Overview</title>
		<description><![CDATA[There isn&#8217;t the time or space to provide an exhaustive study &#8211; whole books have been written about Oracle performance tuning. Instead we&#8217;ll just consider a few of the most important tactics and there&#8217;ll be suggestions for further reading, so you can expand your knowledge of this important subject.
One point that needs to be made [...]]]></description>
		<link>http://www.dbpundit.com/2009/12/oracle-performance-tuning-overview/</link>
			</item>
	<item>
		<title>Brief introduction to UNIX</title>
		<description><![CDATA[Who Uses UNIX ?
UNIX is a very efficient, multi-user, multi-tasking operating system and is used particularly for database servers and Internet servers. Traditionally it has been used by large companies and educational establishments, but due to the popularity of Linux, it is now becoming more widely used.
It is scalable from a small system right up [...]]]></description>
		<link>http://www.dbpundit.com/2009/12/brief-introduction-to-unix/</link>
			</item>
	<item>
		<title>First look at Linux</title>
		<description><![CDATA[Who&#8217;s it for?
Linux is a very efficient, multi-user, multi-tasking operating system and is used particularly for database servers and Internet servers.
Traditionally it has been used by students and other people who enjoy playing with new technologies, but is now used by web site hosting companies, ISPs., educational establishments, hospitals, etc. Large, conservative (non technology) companies [...]]]></description>
		<link>http://www.dbpundit.com/2009/11/first-look-at-linux/</link>
			</item>
	<item>
		<title>7 Steps for I.T. Project Success</title>
		<description><![CDATA[In 2004 KPMG&#8217;s research revealed that I.T. project failure is &#8220;rampant&#8221; with 56% of firms having classified 1 or more I.T. projects as a failure in 2003.
Other research by Gartner has discovered that a full 40% of I.T. projects are canceled and 28% are over budget and/or late.
Research by Bloor has shown that the failure [...]]]></description>
		<link>http://www.dbpundit.com/2009/11/7-steps-for-i-t-project-success/</link>
			</item>
	<item>
		<title>Optimizing Mysql Tables</title>
		<description><![CDATA[Just like you need to defrag and check your file system, it’s important to do the same thing with MySQL tables. If you don’t, you might end up with slow and corrupted database tables. Follow this easy tutorial to set up an automatic optimization for your db.
Speed in MySQL is all about how fast the [...]]]></description>
		<link>http://www.dbpundit.com/2009/11/optimizing-mysql-tables/</link>
			</item>
	<item>
		<title>very basic sql optimization in mysql</title>
		<description><![CDATA[It’s important to know how to write your queries fast. And there are also ways to do your queries faster Inside mysql, called Indexes. They help mysql do the work faster, but you need to tell how…
When you start getting large tables you can sometimes end up with slow running queries.
It’s important to optimize your [...]]]></description>
		<link>http://www.dbpundit.com/2009/10/very-basic-sql-optimization-in-mysql/</link>
			</item>
	<item>
		<title>What is a Database</title>
		<description><![CDATA[Definitions:
A database is a collection of information organized into interrelated tables of data and specifications of data objects.
A table in a relational database is a predefined format of rows and columns that define an entity.
Database tables are composed of individual columns corresponding to the attributes of the object.
In a relational database, a row consists of [...]]]></description>
		<link>http://www.dbpundit.com/2009/07/what-is-a-database/</link>
			</item>
	<item>
		<title>What is Oracle PLSQL</title>
		<description><![CDATA[PL/SQL is Oracle&#8217;s SQL++ programming language providing structure and flow control extensions to SQL. The name PLSQL is derived from the term &#8220;Procedural Language extensions to SQL&#8221;.
On its own, SQL enables you to specify what you want done but not how it is done. However, you often need more control over how data is retrieved [...]]]></description>
		<link>http://www.dbpundit.com/2009/07/what-is-oracle-plsql/</link>
			</item>
</channel>
</rss>
