Technical Blog

Oracle Text offers the CTX_CLS.CLUSTERING package for building clusters. Optimizer Hints We can also "hint" the database optimizer...

Oracle Text ie: Context Oracle text (formerly: interMedia text) in 10g ---------------------------------------------------------------- ...

For an optimal execution plan, always specify the /*+ ordered */ hint when the query window (second argument of a spatial operator) comes fr...

Spatial index creation -- Create the index without any parameters CREATE INDEX geod_counties_sidx ON geod_counties(geom) INDEXTYPE IS MDSYS....