Question : I have a table (refer to below structure) where I track all stock ins and outs. Now I […]
Tag: firebird
SQL Select where value = to another select [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Term for a one-row table?
Question : Is there a specific term to describe a relation with a cardinality of one? I’m thinking particularly of […]
Is it safe to risk multiple Firebird nbackup -L?
Question : I’m using Firebird 3.0 nbackup to lock + copy + unlock each night. If some steps fail or […]
Query speed improvement (opening stock, running stock and closing stock)
Question : I have a table (refer to below structure) where I track all stock ins and outs. Now I […]
Query is too slow (1 second, but needs to improve)
Question : I have generated a very large query. Unfortunality this query is too slow for us. The query is […]
Is it possible in Firebird to create a single index with ascending and descending columns?
Question : For instance, something equivalent to CREATE INDEX Listing_Date_Idx ON ACTIVITY(Listing,Date_ DESC,Time_ DESC); Answer : The syntax for index […]
Improve performance with the WHERE NOT IN sub-select clause
Question : In the following query, I have to count transactions for each customer. However, I have to exclude from […]
Firebird query performance with text search, also some numbers
Question : I have situation as follows: I’m having a table OFERTY of 10k+ records, and when I select * […]
Minimizing Indexed Reads with Complex Criteria
Question : I’m optimizing a Firebird 2.5 database of work tickets. They’re stored in a table declared as such: CREATE […]
- 1
- 2