SQL dotaz
Kosťa MK
kosta na cti.si
Pondělí Listopad 14 15:32:15 CET 2016
Dne 14.11.2016 v 15:25 Tom Meinlschmidt napsal(a):
> explain select * from meta3 where… order by …
addr opcode p1 p2 p3 p4 p5 comment
0 Init 0 215 0 00 /NULL/
1 SorterOpen 14 14 0 k(1,B) 00 /NULL/
2 OpenRead 1 4 0 10 00 /NULL/
3 Rewind 1 196 0 00 /NULL/
4 Rowid 1 2 0 00 /NULL/
5 Column 1 1 3 Unknown 00 /NULL/
6 Null 0 14 0 00 /NULL/
7 Integer 1 15 0 00 /NULL/
8 OpenRead 2 2 0 0 00 /NULL/
9 OpenEphemeral 16 1 0 k(1,B) 00 /NULL/
10 OpenRead 17 10 0 k(2,nil,nil) 02 /NULL/
11 Rowid 1 17 0 00 /NULL/
12 SeekGE 17 18 17 1 00 /NULL/
13 IdxGT 17 18 17 1 00 /NULL/
14 Column 17 1 18 00 /NULL/
15 MakeRecord 18 1 19 C 00 /NULL/
16 IdxInsert 16 19 0 00 /NULL/
17 Next 17 13 0 00 /NULL/
18 Close 17 0 0 00 /NULL/
19 Rewind 16 27 0 00 /NULL/
20 Column 16 0 16 00 /NULL/
21 IsNull 16 26 0 00 /NULL/
22 MustBeInt 16 26 0 00 /NULL/
23 NotExists 2 26 16 00 /NULL/
24 Column 1 6 14 00 /NULL/
25 DecrJumpZero 15 27 0 00 /NULL/
26 NextIfOpen 16 20 0 00 /NULL/
27 Close 2 0 0 00 /NULL/
28 Copy 14 4 0 00 /NULL/
29 Null 0 20 0 00 /NULL/
30 Integer 1 21 0 00 /NULL/
31 OpenRead 4 56 0 2 00 /NULL/
32 OpenEphemeral 19 1 0 k(1,B) 00 /NULL/
33 OpenRead 5 21 0 3 00 /NULL/
34 OpenRead 20 22 0 k(1,nil) 02 /NULL/
35 Rowid 1 23 0 00 /NULL/
36 SeekGE 20 43 23 1 00 /NULL/
37 IdxGT 20 43 23 1 00 /NULL/
38 IdxRowid 20 24 0 00 /NULL/
39 Seek 5 24 0 00 /NULL/
40 Column 5 2 25 00 /NULL/
41 MakeRecord 25 1 19 C 00 /NULL/
42 IdxInsert 19 19 0 00 /NULL/
43 Close 5 0 0 00 /NULL/
44 Close 20 0 0 00 /NULL/
45 Rewind 19 53 0 00 /NULL/
46 Column 19 0 22 00 /NULL/
47 IsNull 22 52 0 00 /NULL/
48 MustBeInt 22 52 0 00 /NULL/
49 NotExists 4 52 22 00 /NULL/
50 Column 4 1 20 00 /NULL/
51 DecrJumpZero 21 53 0 00 /NULL/
52 NextIfOpen 19 46 0 00 /NULL/
53 Close 4 0 0 00 /NULL/
54 Copy 20 5 0 00 /NULL/
55 Column 1 5 6 1 00 /NULL/
56 RealAffinity 6 0 0 00 /NULL/
57 Null 0 26 0 00 /NULL/
58 Integer 1 27 0 00 /NULL/
59 Null 0 28 29 00 /NULL/
60 OpenRead 6 58 0 2 00 /NULL/
61 OpenEphemeral 22 1 0 k(1,B) 00 /NULL/
62 OpenRead 23 24 0 k(2,nil,nil) 02 /NULL/
63 Rowid 1 31 0 00 /NULL/
64 SeekGE 23 70 31 1 00 /NULL/
65 IdxGT 23 70 31 1 00 /NULL/
66 Column 23 1 32 00 /NULL/
67 MakeRecord 32 1 19 C 00 /NULL/
68 IdxInsert 22 19 0 00 /NULL/
69 Next 23 65 0 00 /NULL/
70 Close 23 0 0 00 /NULL/
71 Rewind 22 79 0 00 /NULL/
72 Column 22 0 30 00 /NULL/
73 IsNull 30 78 0 00 /NULL/
74 MustBeInt 30 78 0 00 /NULL/
75 NotExists 6 78 30 00 /NULL/
76 Column 6 1 33 00 /NULL/
77 AggStep 0 33 28 group_concat(1) 01 /NULL/
78 NextIfOpen 22 72 0 00 /NULL/
79 Close 6 0 0 00 /NULL/
80 AggFinal 28 1 0 group_concat(1) 00 /NULL/
81 SCopy 28 26 0 00 /NULL/
82 DecrJumpZero 27 83 0 00 /NULL/
83 Copy 26 7 0 00 /NULL/
84 Null 0 34 0 00 /NULL/
85 Integer 1 35 0 00 /NULL/
86 Null 0 36 37 00 /NULL/
87 OpenRead 8 14076 0 2 00 /NULL/
88 OpenEphemeral 25 1 0 k(1,B) 00 /NULL/
89 OpenRead 26 14301 0 k(2,nil,nil) 02 /NULL/
90 Rowid 1 39 0 00 /NULL/
91 SeekGE 26 97 39 1 00 /NULL/
92 IdxGT 26 97 39 1 00 /NULL/
93 Column 26 1 40 00 /NULL/
94 MakeRecord 40 1 19 C 00 /NULL/
95 IdxInsert 25 19 0 00 /NULL/
96 Next 26 92 0 00 /NULL/
97 Close 26 0 0 00 /NULL/
98 Rewind 25 106 0 00 /NULL/
99 Column 25 0 38 00 /NULL/
100 IsNull 38 105 0 00 /NULL/
101 MustBeInt 38 105 0 00 /NULL/
102 NotExists 8 105 38 00 /NULL/
103 Column 8 1 33 00 /NULL/
104 AggStep 0 33 36 group_concat(1) 01 /NULL/
105 NextIfOpen 25 99 0 00 /NULL/
106 Close 8 0 0 00 /NULL/
107 AggFinal 36 1 0 group_concat(1) 00 /NULL/
108 SCopy 36 34 0 00 /NULL/
109 DecrJumpZero 35 110 0 00 /NULL/
110 Copy 34 8 0 00 /NULL/
111 Null 0 41 0 00 /NULL/
112 Integer 1 42 0 00 /NULL/
113 Null 0 43 44 00 /NULL/
114 OpenRead 10 14311 0 2 00 /NULL/
115 OpenEphemeral 28 1 0 k(1,B) 00 /NULL/
116 OpenRead 29 14316 0 k(2,nil,nil) 02 /NULL/
117 Rowid 1 46 0 00 /NULL/
118 SeekGE 29 124 46 1 00 /NULL/
119 IdxGT 29 124 46 1 00 /NULL/
120 Column 29 1 47 00 /NULL/
121 MakeRecord 47 1 19 C 00 /NULL/
122 IdxInsert 28 19 0 00 /NULL/
123 Next 29 119 0 00 /NULL/
124 Close 29 0 0 00 /NULL/
125 Rewind 28 133 0 00 /NULL/
126 Column 28 0 45 00 /NULL/
127 IsNull 45 132 0 00 /NULL/
128 MustBeInt 45 132 0 00 /NULL/
129 NotExists 10 132 45 00 /NULL/
130 Column 10 1 33 00 /NULL/
131 AggStep 0 33 43 group_concat(1) 01 /NULL/
132 NextIfOpen 28 126 0 00 /NULL/
133 Close 10 0 0 00 /NULL/
134 AggFinal 43 1 0 group_concat(1) 00 /NULL/
135 SCopy 43 41 0 00 /NULL/
136 DecrJumpZero 42 137 0 00 /NULL/
137 Copy 41 9 0 00 /NULL/
138 Column 1 9 10 00 /NULL/
139 Null 0 48 0 00 /NULL/
140 Integer 1 49 0 00 /NULL/
141 OpenRead 12 34 0 5 00 /NULL/
142 OpenRead 30 84 0 k(2,nil,nil) 02 /NULL/
143 Rowid 1 50 0 00 /NULL/
144 SeekGE 30 151 50 1 00 /NULL/
145 IdxGT 30 151 50 1 00 /NULL/
146 IdxRowid 30 51 0 00 /NULL/
147 Seek 12 51 0 00 /NULL/
148 Column 12 4 48 00 /NULL/
149 DecrJumpZero 49 151 0 00 /NULL/
150 Next 30 145 1 00 /NULL/
151 Close 12 0 0 00 /NULL/
152 Close 30 0 0 00 /NULL/
153 Copy 48 11 0 00 /NULL/
154 Null 0 52 0 00 /NULL/
155 Integer 1 53 0 00 /NULL/
156 Null 0 54 55 00 /NULL/
157 OpenRead 31 35 0 k(2,nil,NOCASE) 02 /NULL/
158 Rowid 1 56 0 00 /NULL/
159 SeekGE 31 164 56 1 00 /NULL/
160 IdxGT 31 164 56 1 00 /NULL/
161 Column 31 1 33 00 /NULL/
162 AggStep 0 33 54 group_concat(1) 01 /NULL/
163 Next 31 160 0 00 /NULL/
164 Close 31 0 0 00 /NULL/
165 AggFinal 54 1 0 group_concat(1) 00 /NULL/
166 SCopy 54 52 0 00 /NULL/
167 DecrJumpZero 53 168 0 00 /NULL/
168 Copy 52 12 0 00 /NULL/
169 Column 1 3 13 00 /NULL/
170 Null 0 58 0 00 /NULL/
171 Integer 1 59 0 00 /NULL/
172 OpenRead 2 2 0 0 00 /NULL/
173 OpenEphemeral 33 1 0 k(1,B) 00 /NULL/
174 OpenRead 34 10 0 k(2,nil,nil) 02 /NULL/
175 Rowid 1 61 0 00 /NULL/
176 SeekGE 34 182 61 1 00 /NULL/
177 IdxGT 34 182 61 1 00 /NULL/
178 Column 34 1 62 00 /NULL/
179 MakeRecord 62 1 19 C 00 /NULL/
180 IdxInsert 33 19 0 00 /NULL/
181 Next 34 177 0 00 /NULL/
182 Close 34 0 0 00 /NULL/
183 Rewind 33 191 0 00 /NULL/
184 Column 33 0 60 00 /NULL/
185 IsNull 60 190 0 00 /NULL/
186 MustBeInt 60 190 0 00 /NULL/
187 NotExists 2 190 60 00 /NULL/
188 Column 1 6 58 00 /NULL/
189 DecrJumpZero 59 191 0 00 /NULL/
190 NextIfOpen 33 184 0 00 /NULL/
191 Close 2 0 0 00 /NULL/
192 Copy 58 1 0 00 /NULL/
193 MakeRecord 1 13 57 00 /NULL/
194 SorterInsert 14 57 0 00 /NULL/
195 Next 1 4 0 01 /NULL/
196 Close 1 0 0 00 /NULL/
197 OpenPseudo 35 63 14 00 /NULL/
198 SorterSort 14 214 0 00 /NULL/
199 SorterData 14 63 35 00 /NULL/
200 Column 35 1 2 00 /NULL/
201 Column 35 2 3 00 /NULL/
202 Column 35 3 4 00 /NULL/
203 Column 35 4 5 00 /NULL/
204 Column 35 5 6 00 /NULL/
205 Column 35 6 7 00 /NULL/
206 Column 35 7 8 00 /NULL/
207 Column 35 8 9 00 /NULL/
208 Column 35 9 10 00 /NULL/
209 Column 35 10 11 00 /NULL/
210 Column 35 11 12 00 /NULL/
211 Column 35 12 13 00 /NULL/
212 ResultRow 2 12 0 00 /NULL/
213 SorterNext 14 199 0 00 /NULL/
214 Halt 0 0 0 00 /NULL/
215 Transaction 0 0 164 0 01 /NULL/
216 TableLock 0 4 0 books 00 /NULL/
217 TableLock 0 2 0 authors 00 /NULL/
218 TableLock 0 9 0 books_authors_link 00 /NULL/
219 TableLock 0 56 0 series 00 /NULL/
220 TableLock 0 21 0 books_series_link 00 /NULL/
221 TableLock 0 58 0 tags 00 /NULL/
222 TableLock 0 23 0 books_tags_link 00 /NULL/
223 TableLock 0 14076 0 custom_column_1 00 /NULL/
224 TableLock 0 14300 0 books_custom_column_1_link 00 /NULL/
225 TableLock 0 14311 0 custom_column_2 00 /NULL/
226 TableLock 0 14315 0 books_custom_column_2_link 00 /NULL/
227 TableLock 0 34 0 data 00 /NULL/
228 Goto 0 1 0 00 /NULL/
------------- další část ---------------
HTML příloha byla odstraněna...
URL: <http://list.hw.cz/pipermail/hw-list/attachments/20161114/9a3539f8/attachment-0001.html>
Další informace o konferenci Hw-list