Indexing and CBO - How to help the system do its job
 Your boss bought this expensive product, and now you still need to tell it how to access your data... So how can we make this database thing work for us instead of the other way round? This presentation will generally look for the simplest, and the laziest road to to Efficient systems. Common Joke: The Best way to fix inefficient queries is to not have them. The next best way is to present them the most efficient path into the data, which is why I first want to cover some indexing basics and a few lesser used techniques like IOT and Clusters. If we lead the CBO workhorse to clear and cool water, it might just drink. If you then still depend on the early-morning DBA to kill the inefficient queries: Welcome to the club. We are doing it wrong, but we dont know how to do it any better, or do we? This presentation does not offer the be-all end-all to indexing, CBO and statistics, but it will try to put some guidelines together. It has been stated before: There are no silver bullits to CBO problems. But it wont hurt to look. As long as we realize that we are using "tricks", and realize our risks and limitations. We might get lucky. Speaker(s): Piet de Visser, Logica CMG User Group House, 591-593 Kingston Rd, Wimbledon SW20 8SA Tel: 020 8545 9670 Fax: 0870 9000 335 |
||
