.comment-link {margin-left:.6em;}

Oracle Sponge -- Now Moved To Wordpress

Please use http://oraclesponge.wordpress.com

Monday, August 08, 2005

A List: Accessing Part Of A Table Quickly

I like lists. In particular, I like to make little lists of Oracle features that have some commonality in the way they work, or in what they do.

Today's list is Oracle Features For Accessing Part Of A Table Quickly. Quicker than scanning the whole table anyway, and assuming that the table is not of trivial size. Here's what I have so far:
  1. Creating an Index: obviously.
  2. Making the Table Index-Organized: Is that too similar to Option 1 to justify a new heading, do you think?
  3. Placing The Table In A Cluster: Hash or indexed.
  4. Partitioning The Table: Partition pruning being the key feature here, or through using the PARTITION or SUBPARTITION clauses of the query table expression.
  5. Creating a Materialized View: By precomputing the result set for a query that requires only part of the full table. Query rewrite optional, I suppose.
Off the top of my head, that's all I can think of right now. Other suggestions welcome.


At 2:43 PM, Anonymous Eddie said...

How about parallelism?

At 7:14 PM, Anonymous Anonymous said...

Please put more lists! :D

At 8:53 PM, Blogger David Aldridge said...

Hmm, parallelism.

Certainly a way of speeding table access, but does it fit the criterion for accessing part of a table? I think that if I hadn't put in the materialized view bit then I'd be tempted to reject parallelism but to be honest I think I was on shaky ground there ... to us MV's as a substitute for any of those other methods would really be pushing it, so parallelism has to make the cut.

At 8:53 PM, Blogger David Aldridge said...

More lists? Really?

Oh goodie, I'll think of some others.

At 2:19 AM, Blogger Pete_S said...

How about a list on uses for a synthetic key? ;-)


Post a Comment

<< Home