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:
- Creating an Index: obviously.
- Making the Table Index-Organized: Is that too similar to Option 1 to justify a new heading, do you think?
- Placing The Table In A Cluster: Hash or indexed.
- Partitioning The Table: Partition pruning being the key feature here, or through using the PARTITION or SUBPARTITION clauses of the query table expression.
- 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.
posted by David Aldridge @ 11:57 AM
5 Comments:
How about parallelism?
Please put more lists! :D
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.
More lists? Really?
Oh goodie, I'll think of some others.
How about a list on uses for a synthetic key? ;-)
Post a Comment
<< Home