Index compression comes from Oracle 8i and has quite the same mechanism as table compression. Index compression eliminates duplicate column values in the leaf blocks. Let’s see how it works:
Category Archives: Application integration & Middleware
MySQL Workbench provides several necessary tools in order to manage a MySQL environment. MySQL Workbench 5.2 is available for Windows, Mac and Linux platforms, it encapsulates three main functionalities:
1. SQL Development: Allows connecting to existing databases and run SQL Queries, SQL scripts, edit data and manage database objects. This functionality replaces the ones previously provided by the Query Browser stand-alone application.
2. Data Modeling: Helps to create and manage models, allows forward & reverse engineering and provides capability to compare and synchronize schemas
3. Server Administration: Helps to configure a database server, to setup user accounts and browse status variables and server logs
Let’s have a look deeper in each of those features:
Have you ever noticed strange figures while collecting the Oracle optimizer system statistics ? If so, you need to provide the optimizer with the correct number. In this posting, I will show you how.