function based index not used

I would like to understand why a function based index is not used in the following test case where I would like to index only a subset of the table data: Oracle version is 10.2.0.2 on Windows (or 10.2.0.1 on Linux). <code>bas002> set linesize...

Read More...

---