domain indexes

Domain indexes. Built-in vs DIY.

Posted by sqlmdxon May 4, 2020May 5, 2020in OracleLeave a comment

In this I’ll do a quick performance comparison of built-in Oracle Text index versus the one created using Extensible indexing interface (described in this post).

First of all, Oracle Text option must be installed to use built-in text indexes. This functionality is getting installed under CTXSYS schema.

Speaking about DIY text indexes, it’s mandatory to have privileges to create index types and operators or simply RESOURCE role.

Domain indexes. Quick dive.

Posted by sqlmdxon March 15, 2020May 24, 2020in Oracle1 Comment

Extensible indexing interface

Domain indexes are used to speed up data retrieval for specific domains like text, spatial or image data. Oracle has built in indexes for above mentioned domains but developers can create their own using extensible indexing interface (ODCIIndex).

Let’s consider specific task when this can be useful and discover process end-to-end.