2016: When use new feature -- “set unload fileobj name”? Answer: “set unload fileobj name” was supported for keeping the FILE OBJECT not re-order during load to new DB.
About SYSTEM FILE OBJECT, default setting is [set ...
2016: Why journal full occurs and how to deal with it? Answer: (1) Journal files size are too small
Journal size default value is 4M, if it's caused by journal size too small, you can increase the journal ...
2016: How to use sleep function in SQL statements? Answer: We support an UDF function sleep () for sleeping a while.
For example:
dmSQL> create function to_date.sleep(int) returns int;
dmSQL> select sleep(5);//sleep 5 seconds
Version: 5.3.x, 5.4.x
Product: Normal/Bundle
Platform: Windows/Linux ...
2016: How to use LoadExternalDB to load DB/table/data online? Answer: You can use LoadExternalDB to load external DB into local DB directly via DSN.
If set unload external 'connection string', dmSQL will print "set external db ...
2016: Why and How to rebuild Primary Key? Answer: When face such as below questions we can also consider to rebuild primary key.
For example:
Too much index expansion to cause the performance down (IO and ...