PrepAway - Latest Free Exam Questions & Answers

Category: 000-552

Exam 000-552: IBM InfoSphere Optim for Distributed Systems – V7.3.1

Why might Optim be doing a scan even though you have specified to us e a key to access the table?

When performing a Delete Request, you notice that Optim is doing a table scan even though you have specified a ey Lookup?in the AccessWhen performing a Delete Request, you notice that Optim is doing a table scan even though you have specified a key Lookup in the Access Method of the Table Access Strategy panel for the Delete Request. Why might Optim be doing a scan even though you have specified to us e a key to access the table?

Which two actions will help you to further increase performance of the archive? (Choose two.)

You discovered a slow performance issue during an archive process with delete deferred. By using the Statistical Report and the Relationship Index Analysis, you were able to determine that there was a missing index on one of the tables. The index has been added to the database, and the Statistical Report reflects that the index is being used for a key lookup. Performance has improved somewhat.
Which two actions will help you to further increase performance of the archive? (Choose two.)


Page 4 of 13« First...23456...10...Last »