Managing Oracle Database Tables
A collection of 17 FAQs on database tables for DBA and developers. Clear answers are provided together with tutorial exercises to help beginners on creating, altering and removing tables, adding, altering and removing columns, and working with recycle bin.

Managing Oracle Table Indexes
A collection of FAQ for Oracle DBA on creating indexes and managing indexes. The clear answers and sample scripts provided can be used as learning tutorials or interview preparation guides.

Parallel Clause and Small Tables
If you have multiple CPUs available you may come up with the idea to set parallel execution on every table. The Oracle Optimizer should decide about the degree of parallelism or even if is necessary to use parallel execution at all. What's a great thing on big tables shows up badly on small ones. The split up of all the work over more than one CPU may result in an overhead which exceeds the execution time needed by one CPU by factors. While the Optimizer recognises for index accesses not to use parallel execution it doesn't for full table scans. This sounds reasonable at first hand but consider that often full table scans are the fastest option on smaller tables.

Joining Tables
In our third Oracle DBA lesson we discuss joining tables together and joining tables to themselves.