Question : I have 3 tables. They have table_a 5m records table_b 20m records table_c 20m records I’m performing the […]
Tag: informix
How should I best design the tables and relationships, given the following rules?
Question : In a Pawnshop business, customers pawn, sell or buy items. A contract which specifies the customers information, the […]
Why does NOT IN with a set containing NULL always return FALSE/NULL?
Question : I had a query (for Postgres and Informix) with a NOT IN clause containing a subquery that in […]
Informix DB export to Microsoft SQL Server 2016
Question : I have an Informix Database and a Microsoft SQL Server 2016. My task is to dump the whole […]
How can I control the order of a query regarding to inner join
Question : I have 3 tables. They have table_a 5m records table_b 20m records table_c 20m records I’m performing the […]
Does a cluster index provide more benefits than pre-sorting the load file and creating non-cluster index?
Question : Informix 11.70.TC4DE: CREATE TABLE cluster_tbl ( fk_id INT, data CHAR(2048) ); LOAD FROM “presorted.ld” INSERT INTO cluster_tbl; CREATE […]
How can I control the order of a query regarding to inner join
Question : I have 3 tables. They have table_a 5m records table_b 20m records table_c 20m records I’m performing the […]