Main menu:

Site search

October 2008
S M T W T F S
« Aug    
 1234
567891011
12131415161718
19202122232425
262728293031  

Archive

Archive for 'Oracle'

Oracle Partitioned Indexes - Part 1 (identifying the need)

There’s a company I work with (read, “for”) that seems to be having a bit of trouble getting 4M rows into a table. Typically this isn’t an issue, but the nature of the data, suggests Oracle support, is causing the index to be “unbalanced.” There’s a more technical term for the lack of […]

PHP OCI8 Driver Update

I got a call from Chris Jones over at Oracle about some really cool news. Oracle 11g’s support for Database Resident Connection Pooling (pdf) is now supported in the beta version of PHP’s OCI8 Driver. Chris and I had a long conversation a couple weeks back about where the responsibility for the driver […]

Oracle WITH clause

This is one of the coolest things ever. One of our wonderfully spectacular DBAs (Hi, Brian!) pointed this out and it has saved us a couple times. I know there are better ways to implement this specific example, but it’s to illustrate a point. Here’s what we do now:
CREATE TABLE temp_1 (
user_id […]

Hierarchical Data Sets

Matthew Turland wrote on his blog, “[the nested set] model is simple and intuitive, but it has a drawback: to obtain any significant portion of the hierarchy stored in a table can take up to as many queries as there are levels of depth in the hierarchy.” I like the theory that Matthew talks […]