[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Use-index prevent multiple brackets: documented?

  • Thread starter Thread starter dbeavon
  • Start date Start date
Status
Not open for further replies.
D

dbeavon

Guest
Rob, Did Progress ever clarify the unintentional and non-intuitive impact of USE-INDEX on query performance? I agree that this should be documented. Many developers these days use SQL engines on a regular basis as well. Many would think of "USE-INDEX" as little more than a "hint" to guide the query optimization process (especially if that syntax is used dynamically at run-time and included in a QUERY-PREPARE statement). When using "USE-INDEX" as a "hint", a developer would not assume that the syntax would preclude multiple brackets.

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