T
TheMadDBA
Guest
The KB is somewhat lacking on details on some of the SQL bugs/issues. I can't seem to find any of the issues that specific 10.2A03 hot fixes were created for either. I have been bit by the "update statistics on all columns" on simple queries before (not just complex views). A lot of it seems to depend on the skew of your data and the indexes that are defined. We had an issue a few months back with ranges on character fields that either caused the query to run forever or just crash with complaints of a corrupted index. It seemed to depend on the exact where clause, like including extra fields or changing the values for the indexed columns made the bug appear/disappear. Of course the same 4GL query worked as expected and the index wasn't really corrupted.
Continue reading...
Continue reading...