[firebird-support] Doubts regarding statistics of indexes and tables...

Firebird ver 2.5.7.27050 64 bitsSuperserverWindows Server 2012R2 In firebird, how do you calculate statistics to feed the query optimizer?  Note: I know that the command: 'set statistics index ;' calculate statistics for indexes, but what about tables for example? And my second question: is

Re: [firebird-support] Article for experienced developers looking learn the Firebird Database

Thank you, Karol... I'll take your information and update the article's section on views... With warm regards, Steve

Re: [firebird-support] Article for experienced developers looking learn the Firebird Database

One more words: about views – this is not true that this is redundant to SP. Views are totally different objects. Views can be optimized by Firebird if you join with it with other tables or other views (with one exception if view contain order by). Stored procedure work in the different way.

Re: [firebird-support] Article for experienced developers looking learn the Firebird Database

Hi, article is quite good but the title is something like someone should not try to read it.. regards, Karol Bieniaszewski From: blackfalconsoftw...@outlook.com [firebird-support] Sent: Friday, May 11, 2018 4:52 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] Article for

RE: [firebird-support] Article for experienced developers looking learn the Firebird Database

Thank you. I am always looking for additional Firebird information. -Edward Mendez From: firebird-support@yahoogroups.com Sent: Friday, May 11, 2018 10:53 AM To: firebird-support@yahoogroups.com Subject: [firebird-support] Article for experienced

[firebird-support] Article for experienced developers looking learn the Firebird Database

For many years I have been tracking the development of the Firebird Database Engine and have watched it move from its 1.5 version to its most recent release, version 3.0.3. On a number of occasions I have attempted to work with this database engine. And though I have many years of

Re: [firebird-support] Diagnosing CPU usage

Hello Rudi, Usually, queries with the dozens of millions of index operations are responsible for high CPU usage. You can find them with HQbird MonLogger: get snapshot during the high CPU peak, open it, open tab Statements (disable check "Link to selected attachment"), and sort on