Wednesday, August 11, 2010

Function based indexes in Oracle

If you ever have to query tables in Oracle containing million of records using "is null" in the where clause, then you will notice that your normal indexes won't kick in. They work as prescribed for "is not null", though.

Using a function-based index you can work around that issue. Take a look at the following article which might be quite helpful if you run into the issue: http://www.dba-oracle.com/oracle_tips_null_idx.htm

Labels: , ,

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home