Monthly Archives: June 2012

Oracle SQL Developer Hangs on Linux

If you use SQL Developer 3.x on Linux (tested on Ubuntu, RHEL, but applicable to other distributions, and may happens on Mac) and you do not remember time when you closed it gracefully, but xkill it all the time because … Continue reading

Posted in Linux, Systems, Ubuntu | Tagged , | 12 Comments

Index Clustering factor. One way how to avoid negative performance impact on joins which involves bad clustered indexes.

High Index Clustering factor is popular problem in SQL world. The most known solution for it – rebuild table ordering by columns what are in the index. But in real world, with table size growing exponentially its not always practical … Continue reading

Posted in SQL | Tagged , , , , | 2 Comments