indexes – Page 3 – Learning is not a spectator sport

Apex Interactive Grid and IOT’s

I love the interactive grid in Application Express. And here’s why… (Warning: Ranting mode is now on ) You can

I wrote a post a while back showing how one of the options with an Oracle Text index is to

An AskTom contributor brought to my attention, that direct mode insert on index organized tables now appears possible in 12c.

For “normal” indexes, USER_IND_COLUMNS will contain the column name(s) for an index, but things (appear to) go astray when looking

If you really need your text indexes to be “super dooper” up to date, that is, always in sync with

Richard Foote did a series of informative posts on Index Compression which concludes that there is whole lot of positives

I had an interesting request recently from a developer. “ I have a table created as per below create table

Its not a hard sell to convince anyone that a whopping huge great chunk of compressed column-based memory is going

Every …. single …. time…. Why does index monitoring make me scratch my head and charge off to google so

Anyone who has used Oracle for a while will be familiar with the Parent/Child locking “issue” when it comes to