May
16
awarded Necromancer
May
13
awarded Popular Question
May
2
comment SQL Server - What happens when a row in a table is updated?
The row moves when the column of the clustered index changes. But do you know in wich other circumstances the %%physloc%% can change?
Apr
26
comment Immediate refresh materialized views (MQT) with OUTER JOIN under DB2
We will nevertheless use the solution with the REFRESH in triggers.
Apr
26
comment Immediate refresh materialized views (MQT) with OUTER JOIN under DB2
I meant the query runs "well", not "fast", so a MQT would be a good thing. As you say, we could do it with triggers (3 on each source table) which call REFERESH. But in this case, the complete query will be executed once more. A REFRESH IMMEDIATE materialized view would refresh only the rows which really are concerned by the changes of the master tables.
Apr
24
comment How to log/debug bad requests in tomcat?
RequestDumperValve is a good solution for debugging, but take care of some problems which occur with it. The Umlauts are modified, as an example: issues.apache.org/bugzilla/show_bug.cgi?id=40177
Apr
22
comment Immediate refresh materialized views (MQT) with OUTER JOIN under DB2
Why not REFRESH DEFERRED? Just because my application needs the dataes to be actualized as soon as new dataes come...
Apr
9
awarded Editor
Apr
9
revised Immediate refresh materialized views (MQT) with OUTER JOIN under DB2
Explanation with an exemple
Apr
9
comment Immediate refresh materialized views (MQT) with OUTER JOIN under DB2
My system is a DB2 LUW (under Windows), but does the edition change anything to the problem?
Apr
9
awarded Student
Apr
9
asked Immediate refresh materialized views (MQT) with OUTER JOIN under DB2
Apr
3
comment TreeMap Library for Java?
This question was closed yesterday by Andrew Barber, but I cannot understand why. It is a practicable, answerable question related to programming and it is interresting for other people... Please explain the reason of the "closed as off topic".
Apr
3
awarded Supporter
Mar
27
comment Which units has the relation $E=mc^2$?
Thanks Nathaniel, it was my question. Because the energy is given in joules and the joule depends of kg, meters and seconds, the constant cannot be another one at it is. I had a problem as I though that the energy unit doesn't depend of other ones.
Mar
27
asked Which units has the relation $E=mc^2$?
Mar
26
comment checking dll registration in Windows 7
ListDLLs give the list of currently used (loaded) DLL, not the registried ones.
Mar
25
awarded Supporter
Mar
22
revised close-group problem java RTFEditorKit
Another workaround
Mar
18
comment Advantage and drawback of using iso-files
Yes, I've though about this problem of error resilience. But I will have a copy on a real DVD. Moreover, I suppose the iso-file is ok as long the "ISO 9660 data structure" has no fault. Can somebody confirm it?
1 2 3 4 5