Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: informix

How to join the latest previous record with SQL

By adminPosted on December 29, 2022

Question : I have a table whose schema is like this: CREATE TABLE product_shipping( product_id CHAR(10), product_name CHAR(10), deal_dt DATETIME, […]

SQL Server –> Informix DB Linked Server

By adminPosted on December 19, 2022

Question : After about 3 days of trying, I am unable to create a linked server from SQL Server 2016 […]

How can I control the order of a query regarding to inner join

By adminPosted on June 16, 2022

Question : I have 3 tables. They have table_a 5m records table_b 20m records table_c 20m records I’m performing the […]

How should I best design the tables and relationships, given the following rules?

By adminPosted on September 30, 2021

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?

By adminPosted on August 28, 2021

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

By adminPosted on May 30, 2021

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

By adminPosted on January 5, 2021

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?

By adminPosted on October 1, 2020

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

By adminPosted on September 22, 2020

Question : I have 3 tables. They have table_a 5m records table_b 20m records table_c 20m records I’m performing the […]

Recent Posts

  • Get column names and data types of a query, table or view
  • What is the effect on primary keys when moving a CLUSTERED index to a new filegroup?
  • Order of returned rows with IN statement
  • Do not want to allow Queries to take more than x minutes?
  • How would i create a report involving multiple many to many relationships
  • web interface port for oracle 11g
  • Getting the exact and closest Search using CONTAINS/CONTAINSTABLE in SQL
  • How can I check if a user have a quota on tablespace
  • Can alias in SQL Server contain slash?
  • Why store /var/lib/mysql when you can just create SQL dumps for backup purposes?
  • Fix OGR2OGR “failed when converting the varchar value to data type int” issue in the MSSQL table –
  • Sum on distinct and group by
  • Is a join optimized to a where clause at runtime?
  • Simple select is taking too long
  • GROUP BY with subqueries for a Group?
  • SERVERPROPERTY(‘Edition’) AS [Edition]
  • Do MySQL sub-queries essentially use as much overhead as separate queries?
  • select fieldvalues and column-description of a table
  • Secure database access from particular applications
  • How to optimize and estimate DB recovery times?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding