Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Function based indexes and virtual columns

unknown-879931Feb 26 2014 — edited Mar 3 2014

I have just read Oracle documentation about FBI. In the part of optimization with function-based indexes, it is saying that "A virtual column is useful for speeding access to data derived from expressions.". Here is the link Indexes and Index-Organized Tables.

My question is, doesn't Oracle already create a virtual column when we create a function-based index?

Regards

Charlie

This post has been answered by Chris Antognini on Feb 26 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2014
Added on Feb 26 2014
17 comments
6,849 views