The Fastest Way into your data: Hash-Clusters

We examine the under-used construction of Hash Clusters, specifically Single-Cluster-Hash-Tables.
It is demonstrably the Fastest way to get to a record.
But there are some downsides too. We will also examine the risks of using STHC and how to mitigate for the inevitable problems. Finally, there are some tips on where to look for alternatives if the data or its intended usage is un-suitable for STHC.

Detalji o predavanju

Vrsta: Predavanje / Lecture

Razina težine: Vrlo detaljno i stručno / Expert

Poželjno iskustvo slušatelja: Napredni (3 g. i više) / Advanced

Poželjna funkcija slušatelja:
Krajnji korisnik / End User
DBA
Developer
Dizajner / Designer

Predviđeno vrijeme trajanja rada - aktivnosti: 60 min

407_de Visser Still using Ratios .pdf 819,58 kB

O predavaču

Piet de Visser

Logica - Oracle ACE

Piet is an experienced Database Consultant and Administrator, specializing in Oracle databases and High-Availability. He is in IT since 1987, and specializes in Oracle- and Databases-related technology since 1994. He combines technical knowledge with extensive experience in global organizations. His energetic personality and language-skills makes him ideal for pioneering and ground-breaking projects in a multi-national environment. He also invests a lot of effort in maintaining a network of Like-Minded Oracle specialists worldwide and is a regular speaker at international user group events and symposia. Oh, and Piet has a preference for Simple solutions.
Piet de Visser is Oracle ACE.