[progress Communities] [progress Openedge Abl] Forum Post: Re: Dynamic Queries With Where,...

  • Thread starter Thread starter Peter Judge
  • Start date Start date
Status
Not open for further replies.
P

Peter Judge

Guest
I’d point you to the slides from Paul Koufalis’ Index part of his and my “ Mastering 4GL Code Performance - Profiling & Indexing” talk from the recent PUG challenge in Prague, if they were posted. He does a good job of describing the index rules and how they’re selected for a query. Attached are the slides. Slides 27-28 describe the rules, and then you’ll see a series of worksheets describing how you can figure out which indexes are used. You can see which indexes are used and where the sorting happens via the LOG-MANAGER’s QryInfo LOG-ENTRY-TYPE.

Continue reading...
 
Status
Not open for further replies.
Back
Top