In V3R2M0, a new function of the query optimizer - the index advisor - gives you a valuable tool in your search for the perfect index. The index advisor simplifies the steps necessary to determine what key fields you should include in an index to help the performance of a query. The advisor analyzes the entire selection for a query and determines what key field(s) the index would need to match exactly the nonjoin selection for that query. The advisor then checks that information against the ...

REGISTER NOW TO ACCESS THIS ARTICLE

All registered users get access to premium content on iPro Developer for free.

Already registered? here.