| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: interMedia Text problems?
On Mon, 27 Sep 1999 10:37:22 -0700, "Michael Schoen"
<mschoen_at_zealmedia.com> wrote:
>I'm wondering if anyone is bumping into this same issue...
>
>I've created a text index in Oracle8i (Standard, NOT Enterprise). Everything
>appears to be configured correctly, and the index creation is successful. I
>can execute "context" queries against the table, and the correct results are
>returned.
>
>However, the index is not being used! Though the context extensions are
>working, it appears that Oracle is still doing a full table scan. I've come
>to this conclusion based on both performance (ie., it takes 3-5 seconds to
>return results on a table with only 100,000 records), and based on an
>explain plan (which reports a full table scan).
>
>According to Oracle support, this is a known bug -- because Oracle 8i
>Standard doesn't support bitmap indices, and interMedia indices don't work
>properly without bitmaps. According to support, I need to wait until 8.1.6,
>which will resolve the issue.
>
>So: any ideas? I thought that the context SQL extensions could only work
>with the index -- ie, how can Oracle use the extended search semantics
>WITHOUT using the index? How could Oracle sell an extension (interMedia)
>that just doesn't work?
You raise a very valid point, I won't even attempt to try and explain it away. It is a bug that has been corrected in Oracle8i 8.1.6, and there is a backport request (979101) for this to be in the patch release 8.1.5.2.
In Oracle8i, interMedia Text now exploits an 8i-specific enhancement called extensible indexing framework. In short, interMedia Text now operates looks (from the DBA perspective) just like an ordinary b-tree index.
In your case, you have certainly created and are using the interMedia Text index. Without its existence, your CONTAINS queries would fail on that column. It's just that interMedia Text isn't "being all it can be" when it comes to efficiently locating your data.
Hope this helps.
>
>Any help would be appreciated. Thanks,
>
>Michael
>
>
>
>
Thanks!
Joel
Joel R. Kallman Oracle Service Industries
Columbus, OH http://govt.us.oracle.com jkallman@us.oracle.com http://www.oracle.com
 |
 |