Changes between Version 3 and Version 4 of AdvancedApplicationDesign_v2

Timestamp:

08/30/25 12:40:39 (8 days ago)

Author:

212028

Comment:

--

AdvancedApplicationDesign_v2

@@ -15 +15 @@
 join kazna kz on kz.kontrola_id = ko.kontrola_id
 group by godina, li.li_ime
-order by godina, li.li_ime;
+order by godina;
 
 }}}
@@ -59 +59 @@
     group by godina, li_ime
 )
-order by godina, li_ime;
+order by godina;
 
 }}}
@@ -77 +77 @@
 join instanca_na_linija inl on inl.li_id = li.li_id
 join vozenje v on v.inl_id = inl.inl_id
-group by godina, li.li_id, li.li_ime, li.li_pravec
-order by godina, li.li_id;
+group by godina, li.li_ime, li.li_pravec
+order by godina;
 
 }}}
@@ -143 +143 @@
     group by godina, tb_ime
 )
-order by q1.godina, q1.tb_ime;
+order by q1.godina;
 
 }}}
@@ -223 +223 @@
 {{{#!div
 {{{#!sql
+create index idx_vozenje_pnl_id on vozenje(pnl_id);
+}}}
+}}}
+{{{#!div
+{{{#!sql
+create index idx_vozenje_patnik_k_id on vozenje(patnik_k_id);
+}}}
+}}}
+{{{#!div
+{{{#!sql
 create index idx_vozenje_hour on vozenje(extract(year from vozenje_start));
+}}}
+}}}
+
+==== Индекси за {{{Postojka na linija}}} табелата ====
+
+{{{#!div
+{{{#!sql
+create index idx_pnl_p_id on postojka_na_linija(p_id);
+}}}
+}}}
+{{{#!div
+{{{#!sql
+create index idx_pnl_li_id on postojka_na_linija(li_id);
+}}}
+}}}
+
+==== Индекси за {{{Bileti}}} табелата ====
+
+{{{#!div
+{{{#!sql
+create index idx_bilet_tb_id on bilet(tb_id);
+}}}
+}}}
+{{{#!div
+{{{#!sql
+create index idx_bilet_year on bilet(extract(year from b_datum_na_kupuvanje));
 }}}
 }}}