SDB4323z Week 6 Unit 3 Performance During Table Access

In the previous lab, students were exposed to ABAP Dictionary. The activities were mostly on creating data objects i.e data elements, domain, structure i.e nested and deep structure and also table. In this week's lab, the students were introduced to two approached in improving performance during table access namely index and table buffering. For this topic, student should be able to see the difference between the two. Both improve table access performance but what about the difference.

I am well aware that majority of the students have not completed Unit 2 exercises so I gave them the opportunity to do the 5 exercises. Most of them are about to finish which is good. I also realized that there were one or two who just started doing the exercise. They were asking me fundamental questions which I believed have been explained last week and should not be explained again when most of the students are about to finish the exercises. My advice to these students, they have to catch up. They have to make time. If they missed, they need to ask their colleagues and take that initiative to complete the activity. Do not wait until the following week when everyone is making progress and you just started doing the exercise. Nonetheless, I am happy to see student who take the initiative to complete it. These students slot in their time to be at the lab doing the exercises. There are students who asked me through FB Messenger or Telegram. I appreciate this. 

Luckily, Unit 3 has only one exercise BUT the table that the students created at the end of exercise 5 of Unit 2 need to be populated. The SAP program that is used to populate the tables has errors so students can't use the program. A quick solution was to populate the tables manually. This is because if a table has no records, then there is no point to create index.