Changes between Version 10 and Version 11 of OtherTopics

Timestamp:

02/13/26 21:11:54 (2 weeks ago)

Author:

231136

Comment:

--

OtherTopics

@@ -274 +274 @@
 
 {{{
-select *
-from songs s
-left join albums a on a.id = s.album_id
-where s.album_id = :albumId; 
+SELECT *
+FROM songs s
+LEFT JOIN albums a ON a.id = s.album_id
+WHERE s.album_id = :albumId; 
 }}}
 
@@ -289 +289 @@
 
 Без индекс добиваме:
+{{{
 +-------------------------------------------------------------------------------------------------------------------------------------+
 |QUERY PLAN                                                                                                                           |
@@ -306 +307 @@
 |Execution Time: 57.726 ms                                                                                                            |
 +-------------------------------------------------------------------------------------------------------------------------------------+
+}}}
 
 Просечно `Execution time` е **56,24ms**. 
 
 По додавање на индекс:
+{{{
 +-------------------------------------------------------------------------------------------------------------------------------------+
 |QUERY PLAN                                                                                                                           |
@@ -326 +329 @@
 |Execution Time: 0.090 ms                                                                                                             |
 +-------------------------------------------------------------------------------------------------------------------------------------+
+}}}
 
 Просечно `Execution time` е сега **0.092ms**. Можеме да забележиме користење на индекс преку `Bitmap Index Scan on idx_songs_album`.