Firebird tipy a triky na Telegramu

26 views
Skip to first unread message

Zoran Bonuš

unread,
Dec 16, 2019, 3:03:48 AM12/16/19
to Firebird (CZ)
Jsem právě objevil tento Telegram kanál a musím hned sdílet, dobré tipy a triky na FB

Za všechny poslední příspěvek:

SQL> select count(*) from SYNC_DATA where DATE_IN > '01-AUG-2019';

                COUNT
=====================
              3846157

Current memory = 17092054352
Delta memory = 0
Max memory = 17115757856
Elapsed time = 6.339 sec
Buffers = 512000
Reads = 0
Writes = 0
Fetches = 3900383
SQL> select count(*) from SYNC_DATA where DATE_IN > date '01-AUG-2019';

                COUNT
=====================
              3846157

Current memory = 17092054368
Delta memory = 16
Max memory = 17115757856
Elapsed time = 4.933 sec
Buffers = 512000
Reads = 0
Writes = 0
Fetches = 3900383
Reply all
Reply to author
Forward
0 new messages