Presentation Title: How to Avoid a Salted Banana
Speaker: Mr Lothar Flatz OakTable
Company: Diso AG
Presentation abstract: We address a challenging issue in the context of SQL statement tuning and optimal execution plans. There is one category of queries that is very difficult to tune. These are queries with independent and not very selective search criteria on two (or more different) tables.

One prominent example is an address search when based on a person's name and a street address. These queries are characterized by a potentially high number of throw away rows. Throw away rows are retrieved, but do not make it into the final result.

The title refers to a joke - told at the beginning - that quintessentially states that you should not make an extra effort for something you are going to throw away.

We will see a patented technique describing how we can keep the effort to retrieve throw away rows at a reasonable level.

Presentation begins: 07/12/2014 12:30
Presentation duration: 50
Presentation content level: 2 (1 = indepth, 5 = strategic overview)
Audience experience: Basic Working Knowledge
Audience function: Product Expert
Speaker biography: Origin Austrian, Age: 53, Masters degree in economy and computer science from Universtity of Vienna. Started to with Oracle Version 5 in 1989.Worked 15 years for Oracle. Former member of Oracle RWPG. Current Oaktable member. Specialises in performance Tuning
Related topics: OakTable World: OakTable
Hall: 13