Www.allegroconsultants.com DB-12 - Pick An Index, Any Index… Michael Lonski Allegro Consultants, LTD. - презентация

1 DB-12 - Pick An Index, Any Index… Michael Lonski Allegro Consultants, LTD.

2 Whats Next… Prepare

3 Who I Am… Started working with Progress® v3 (1986) Founded Allegro Consultants in 1993 Internationally recognized speaker Author of Coding Smart book on ADM2 Punster and Frequent Talker

4 …And Why I Am Here Overview index rules Practical tools, not bookish theory Focus on fact, not guesswork Compile time information Run-time information Show off skill at alliteration

5 Whats Next… Prepare Predict

6 Hierarchy For A Single Index 1. Unique index with all components involved in the equality matches 2. Most active equality matches 3. Most active range matches 4. Most active sort matches 5. First index alphabetically by index name 6. The primary index

7 Multiple Index Usage If indexes are available for both sides of WHERE... AND/OR, more than one index can be used Multiple indexes will *only* be used to assist in bracketing records

8 WHERE…AND… WHERE clause includes the use of AND All components of each index are involved in equality matches No unique indexes are involved

9 WHERE…OR… WHERE clause includes the use of OR Both the left and right side of the OR contain at least the lead component of an index These lead components are involved in either equality or range matches

10 Whats Next… Prepare Predict Prevent

11 Breaking The Rules FIND … WHERE ROWID ( ) = … USE-INDEX …

12 Breaking The Index WHERE Family.CoveredOnBenefits WHERE … MATCHES … WHERE NOT … WHERE IF … THEN … = vcInput ELSE TRUE WHERE SUBSTRING (…) = A

13 Whats Next… Prepare Predict Prevent Plan

14 XREF Information COMPILE prog.p XREF prog.xref FIND FOR EACH

15 Demo – XREF-demo.p

16 XREF Information COMPILE prog.p XREF prog.xref DEFINE Query CREATE Query

17 Demo – Query-demo.p

18 Whats Next… Prepare Predict Prevent Plan Prove

19 If A Query Could Talk… qryCust Did I error? Did I bracket? What did I use?

20 How To Ask qryCust DEFINE QUERY qCust QUERY qCust: DEFINE VARIABLE vhQryCust AS HANDLE CREATE QUERY vhQryCust vhQryCust = QUERY qCust:HANDLE

21 What to Ask qryCust Did I error? Did I bracket? What did I use? vhQry:INDEX-INFORMATION() ERROR-STATUS:NUM-MESSAGES ENTRY(1, vhQry:I-I) = WHOLE- INDEX

22 Demo – wQueryTest.w

23 Whats Next… Prepare Predict Prevent Plan Prove Process

24 OpenEdge® 10 – Log Manager New features in OpenEdge 10 Both command-line and run-time controls Highly configurable

25 Log Manager Controls Command Line -clientlog -logentrytypes -logginglevel -numlogfiles -logthreshold LOG-MANAGER :LOGFILE-NAME :LOG-ENTRY-TYPES :LOGGING-LEVEL :NUM-LOG-FILES :LOG-THRESHOLD

26 Demo – Logging-demo.p

27 Now that Ive rambled on, are there any questions?

28 Thanks for attending…