1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211
| CREATE DATABASE '..\Data\Base.fdb' page_size 4096 DEFAULT CHARACTER SET WIN1252;
-- ===========================
-- Création de la table 'test'
-- ===========================
create table test (
id integer generated by default as identity not null primary key,
dat date not null
);
-- =========================
-- Création Index sur 'test'
-- =========================
create index idx on test (dat);
-- =====================
-- Insertion dans 'test'
-- =====================
insert into test (dat) values ('2017-12-01');
insert into test (dat) values ('2017-12-02');
insert into test (dat) values ('2017-12-03');
insert into test (dat) values ('2017-12-04');
insert into test (dat) values ('2017-12-05');
insert into test (dat) values ('2017-12-06');
insert into test (dat) values ('2017-12-07');
insert into test (dat) values ('2017-12-08');
insert into test (dat) values ('2017-12-09');
insert into test (dat) values ('2017-12-10');
insert into test (dat) values ('2017-12-01');
insert into test (dat) values ('2017-12-02');
insert into test (dat) values ('2017-12-03');
insert into test (dat) values ('2017-12-04');
insert into test (dat) values ('2017-12-05');
insert into test (dat) values ('2017-12-06');
insert into test (dat) values ('2017-12-07');
insert into test (dat) values ('2017-12-08');
insert into test (dat) values ('2017-12-09');
insert into test (dat) values ('2017-12-10');
insert into test (dat) values ('2017-12-01');
insert into test (dat) values ('2017-12-02');
insert into test (dat) values ('2017-12-03');
insert into test (dat) values ('2017-12-04');
insert into test (dat) values ('2017-12-05');
insert into test (dat) values ('2017-12-06');
insert into test (dat) values ('2017-12-07');
insert into test (dat) values ('2017-12-08');
insert into test (dat) values ('2017-12-09');
insert into test (dat) values ('2017-12-10');
-- ================
-- Vidage de 'test'
-- ================
select * from test;
ID DAT
============ ===========
1 2017-12-01
2 2017-12-02
3 2017-12-03
4 2017-12-04
5 2017-12-05
6 2017-12-06
7 2017-12-07
8 2017-12-08
9 2017-12-09
10 2017-12-10
11 2017-12-01
12 2017-12-02
13 2017-12-03
14 2017-12-04
15 2017-12-05
16 2017-12-06
17 2017-12-07
18 2017-12-08
19 2017-12-09
20 2017-12-10
ID DAT
============ ===========
21 2017-12-01
22 2017-12-02
23 2017-12-03
24 2017-12-04
25 2017-12-05
26 2017-12-06
27 2017-12-07
28 2017-12-08
29 2017-12-09
30 2017-12-10
commit;
-- ===========
-- Requête N°1
-- ===========
set stats on;
select * from test where dat = '2017-12-03';
ID DAT
============ ===========
3 2017-12-03
13 2017-12-03
23 2017-12-03
Current memory = 12254232
Delta memory = 24312
Max memory = 12316640
Elapsed time= 0.007 sec
Buffers = 2048
Reads = 0
Writes = 2
Fetches = 12
-- ====
-- Show
-- ====
Show table test;
ID INTEGER Not Null Identity (by default)
DAT DATE Not Null
CONSTRAINT INTEG_1:
Primary key (ID)
Show Indexes test;
IDX INDEX ON TEST(DAT)
RDB$PRIMARY1 UNIQUE INDEX ON TEST(ID)
set stats off;
exit;
Database "E:\23.FIREBIRD\99.EXERCICES\DATA\BASE.FDB"
Database header page information:
Flags 0
Generation 13
System Change Number 0
Page size 4096
ODS version 12.0
Oldest transaction 6
Oldest active 7
Oldest snapshot 7
Next transaction 10
Sequence number 0
Next attachment ID 3
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 9, 2017 19:08:32
Attributes force write
Variable header data:
*END*
Database file sequence:
File E:\23.FIREBIRD\99.EXERCICES\DATA\BASE.FDB is the only file
Analyzing database pages ...
TEST (128)
Primary pointer page: 224, Index root page: 225
Total formats: 1, used formats: 1
Average record length: 13.00, total records: 30
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 12.00, compression ratio: 0.92
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 22%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index IDX (1)
Root page: 230, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 3.47, total dup: 20, max dup: 2
Average key length: 2.43, compression ratio: 1.64
Average prefix length: 3.57, average data length: 0.43
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY1 (0)
Root page: 229, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 4.07, total dup: 0, max dup: 0
Average key length: 3.00, compression ratio: 0.66
Average prefix length: 0.93, average data length: 1.03
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Appuyez sur une touche pour continuer... |
Partager