Sql tilida index yaratish. Tasavvur, view yaratish va undan foydalanish

Men o’zimga berilgan predmet soha bo’yicha yaratgan MB ni 
Builder dasturiga bog’ladim va Ma’lumotlar bazasi yordamida 
oddiy interfeys yaratdim. 
mysql> insert into ishchilar 
-> values(1,'Nuriddin','Ergashev','3 yil','3 $','Namangan sh'); 
Query OK, 1 row affected (0.00 sec) 
mysql> insert into ishchilar 
-> values(2,'Mirzaakram','Meliboyev','5 yil','3 $','Namangan sh'); 
Query OK, 1 row affected (0.01 sec) 
mysql> select * from ishchilar; 
+----+------------+------------+-----------+--------+-------------+ 
| id | ismi | familiyasi | ish_staji | maoshi | manzili | 
+----+------------+------------+-----------+--------+-------------+ 
| 1 | Nuriddin | Ergashev | 3 yil | 3 $ | Namangan sh | 
| 2 | Mirzaakram | Meliboyev | 5 yil | 3 $ | Namangan sh | 
+----+------------+------------+-----------+--------+-------------+ 
2 rows in set (0.00 sec) 
 

---

mysql> select * from ishchilar; 
+----+------------+------------+-----------+--------+--------------+ 
| id | ismi | familiyasi | ish_staji | maoshi | manzili | 
+----+------------+------------+-----------+--------+--------------+ 
| 1 | Nuriddin | Ergashev | 3 yil | 3 $ | Namangan sh | 
| 2 | Mirzaakram | Meliboyev | 5 yil | 3 $ | Namangan sh | 
| 3 |OYBEK | YO’LDASHALIYEV | 20 yi | 7 $ | Namangan sh' | 
+----+------------+------------+-----------+--------+--------------+ 
3 rows in set (0.00 sec) 

---

Xulosa 
Men bu SQL tili orqali savdo tashkiloti haqida dastur tuzdim kelajakda buni 
takomillashtirilsa non markazidagilar uchun qulaylik vaqtni tejash uchun 
judayam foydali bo’ladi degan umiddama