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

[hunterkiller]

Another trick to add to the collection, thx a lot!

[TheRafagomez]

Hola Christian, entonces el motor del db2 te va recomendando la creación de índices en base al análisis de las consultas que se van creando?. Para este caso dedujo que si haces la consulta por el precio se necesitaba crear un índice por precio.

[pixycrow]

Hi. It's very interesting! A question if possible. If I create an INDEX and see an improvement in my queries, in case of changes to the physical layout of the table, should the index be recreated or does it get associated and updated? I hope the question is clear...

[RajalakshmiRaji-pnmz]

Hi Chris, could you please improve the audio quality of your videos. Little louder please.

[BigHotCrispyFry]

Thanks for the video! what is the RCDFMT for?