Subscribe to this list via RSS Blog posts tagged in Databases

Posted by on in Blogs
Optimizing Concurrent Queries: Sequential Scans Broadly speaking, there are two ways to read records from a database. A sequential scan means reading the records in storage order, rejecting those which don't match the WHERE clause of the query. An indexed scan means using an index to find the desired records, then going directly to them on disk (or, if it's lucky, finds the pages in the cache). Sequential scans are much faster than index lookups when you will be reading a significant proportion of the records in a table. This is because hard ...
Tags: Databases

Posted by on in Blogs
Oracle Plans Per-core Licensing CPU makers, unable to make clock rates keep up with transistor counts, are planning multi-core CPUs -- essentially multiple CPUs on a single chip. Software makers, for the most part, plan to count a multi-core CPU as a single processor for licensing purposes. Except Oracle: The problem, [the chipmakers] say, is that as more logic cores are squeezed into each chip, the software licenses will increase in cost accordingly--but out of all proportion to the cost of the hardware. "Oracle is probably t...
Tags: Databases

Check out more tips and tricks in this development video: