Technical Blog

The Below example shows the difference in execution plan when a composite index is created   SELECT d.ITEM_ID,d.ITEM_DESC,D.UNIT,d.ITEM_...

Tuning the LIKE-clause (by using reverse key indexes) For tuning Like operator (like '%SON') is to create a REVERSE index - and th...

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

Re: alter table move Processing the code select * from tab where P1 = 110 last a few seconds. After the code alter table tab enable row move...