Tag: Index

  • Oracle Index compression for range scan on file names

    Oracle Index compression for range scan on file names

    Oracle Index compression for range scan on file names Do you have tables with a column storing filenames? Long filenames with full path? If this is the case, then you probably realized how an index on this can be large. And when looking at the values sorted, you have seen the inefficiency of it: a

    Explore →

  • Unindexed Foreign Keys in Oracle and PostgreSQL

    Unindexed Foreign Keys in Oracle and PostgreSQL

    Unindexed Foreign Keys in Oracle and PostgreSQL In Oracle we need to have a index on the foreign key column as soon as we have the intention to delete from the parent row, or a locking situation may block all transactions around the child table. PostgreSQL has a similar way to manage isolation, with MVCC,

    Explore →