Reputation
456
Top tag
Next privilege 500 Rep.
Access review queues
Badges
5 12
Newest
 Excavator
Impact
~11k people reached

Aug
4
awarded  Excavator
Aug
4
revised Informix: is it necessary to update statistics on views?
Fix trivial typos
Aug
3
answered Multiple table rows in one row Informix
Aug
3
comment How can I control the order of a query regarding to inner join
Note that the Informix DATE function returns a value with no time component. Given that the constant is an approximation to an Informix DATETIME YEAR TO FRACTION(3) literal, there is conversion work going on there. It would be helpful to know the type of the a_dt column. The chances are that there are better ways to write that condition, but which is best depends on the type of a_dt. Which version of Informix and which platform you're running on might be relevant. It is always relevant to ask 'have you run UPDATE STATISTICS (or, depending on the version, has the system done it for you)?'
Aug
3
answered Retrieve one of two possible values from 1 table in INFORMIX
Aug
3
comment Retrieve one of two possible values from 1 table in INFORMIX
There's a lot of information missing (like column names). Presumably, this problem is resolved by now in the real world, so there's limited benefit to pointing this on DBA.SE.
Aug
3
suggested approved edit on Informix: is it necessary to update statistics on views?
Aug
3
awarded  Constituent
Jul
28
answered SSRS and Informix connection
Jul
27
awarded  Caucus
May
4
comment Optimizing an Informix query — Specify architectural solutions if possible too (like caching service)
That's going to take a lot of digesting. There are over 700 lines in the query plan information. The SQL alone is about 50 lines. It ain't happening tonight — that is, I'm off to bed and won't be working on this until tomorrow evening at the earliest. Are your statistics up to date? These days, it is more nearly automatic than it was, say, 5 years ago. Seeing SKIP 10000 FIRST 50 is worrying; there've been 200 sets of 50 rows prior to that? How many rows are there in the full data set? The estimate is 11k or so, if I scanned the query correctly, but what's the actual number?
May
3
revised Optimizing an Informix query — Specify architectural solutions if possible too (like caching service)
Provide link to Redis; unquote NoSQL since it really isn't code.
May
3
comment Optimizing an Informix query — Specify architectural solutions if possible too (like caching service)
I agree with @zgguy; there isn't enough information in the question to be able to provide a meaningful answer. To provide a better answer, we'd need to see outline schemas for the tables (the columns mentioned in the query, the size of the other columns, the number of rows in each table, the indexes on each table), and the query itself. Studying the query plan (output from SET EXPLAIN ON) will provide insight into what the query is doing. Do the parameters of the query change each time it is used? Do the SKIP and FIRST clauses make it worse? How many rows in the result set, and how wide?
May
3
suggested approved edit on Optimizing an Informix query — Specify architectural solutions if possible too (like caching service)
May
3
revised Optimizing an Informix query — Specify architectural solutions if possible too (like caching service)
improve title and other trivia.
May
3
suggested approved edit on Optimizing an Informix query — Specify architectural solutions if possible too (like caching service)
May
3
awarded  Informed
Mar
20
answered Informix Server Rejected Connection
Jan
20
answered Informix: is it necessary to update statistics on views?
Jul
28
revised How to join the latest previous record with SQL
Use correct () instead of {} in CREATE TABLE statement; indent body of statement