Additional indices („indexes“ in Oracle’s English) apart from the primary key are extremely important for the performance of databases. There is this magic behind it, when a complicated query with multiple joins runs slowly and magically becomes faster when adding the right index and the right hint or does not become faster at all, even …
„Indexing of Database Tables II (additional indices)“ weiterlesen