Only results after update statistics

Discussion forum about all things SqlBase.
m.burkhardt
Germany
Posts: 50
Joined: 19 Feb 2020, 10:13
Location: Duisburg, Germany

Only results after update statistics

Post by m.burkhardt » 01 Dec 2016, 12:54

Hello, we have a fault behavior with our SQLBASE 11.6 and the same on 12.0.1!
Description:
Offline Database: no Client writes into the database!!!
-> check database -> OK!!
-> Execute a complex select-statement (with joins) -> no results!! (That’s Wrong!!)
-> Execute each table separated! Each result set counted 16 Rows
-> Execute the complex select-statement again -> no results!!
-> UPDATE STATISTICS to only one of the involved table!
-> Execute the complex select-statement again -> 16 Rows!
What can I do!


Thanks in advance

Greetings from Germany
Michael

EwaldP
Austria
Posts: 343
Joined: 07 Mar 2017, 08:00
Location: Austria

Re: Only results after update statistics

Post by EwaldP » 13 Dec 2016, 09:08

Hi Michael,

I had a similar problem years ago. The problem occurred by joining two tables with columns defined char(120). I converted to char(40) and everything was ok.
Ewald P. Palmetshofer
EDV-Hausleitner GmbH
4020 Linz
www.edv-hausleitner.at

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests