Coding in RPG (IBM i/AS400). When to create a SQL index.
In this example video, I'd like to show you how can I know that a SQL index should be created for a table.
If you don't know, the database recommends creating indexes if it sees that they are necessary. I show you how to get that information, with a simple example.
Please, let me know what you think about it. Leave your comments below.
Don't forget to subscribe!
#ibmi #ibm #rpg #rpgle #rpgfree #newvideo #ibmtraining #ibmcoding #rpgtraining #as400 #common #SQLindex #indexadvisor #whencreatingINDEXes
0:00 Introduction
0:40 Creating an SQL TABLE with CREATE TABLE for the example
1:55 Adding data to the table with INSERT INTO
2:37 Using SELECT to make some queries to my TABLE
4:06 When do I have to create a INDEX. Let's see the INDEX advisor
5:52 Creating a necessary index with CREATE INDEX
7:01 Let's see again the index advisor, after creating the index
7:22 Final comments and end