Presentation Title: Calculating Selectivity
Speaker: Mr Jonathan Lewis Oracle ACE Director OakTable Speaker Awards Lifetime
Company: JL Computer Consultancy
Presentation abstract: This presentation is for people who are capable of deriving Oracle's order of action from an execution plan, but want to know more about how the Optimizer has derived it's estimates of the number of rows (cardinality) that will be returned.
Presentation begins: 07/12/2014 13:30
Presentation duration: 50
Presentation content level: 4 (1 = indepth, 5 = strategic overview)
Audience experience: Basic Working Knowledge
Audience function: Product Expert
Speaker biography: Jonathan Lewis is a well-known figure in the Oracle world with more than 26 years experience using the software. He has published three books about Oracle - the most recent being "Oracle Core" published by Apress Nov 2011 - and contributed to three others. He runs a couple of websites and contributes fairly regularly to newsgroups, forums, and User Group magazines and events around the world. Jonathan has been self-employed for most of his time in the IT industry. For the last 20 years he has specialised in short-term assignments, typically of a design, review, or trouble-shooting nature - often spending no more than two or three days on a client site to address problems . He runs seminars about using Oracle all over the world and has visited more than 50 different countries (and more than a dozen US states) to talk about, or trouble-shoot, Oracle systems.
Related topics: OakTable World: OakTable
Hall: 13