Hello Matheus,
Generator values are stored on generator pages. In shared cache
architectures (i.e. SuperServer) a connection that changes a generator
value
gets a transient write lock on the page, makes its change and releases
the
page.
This page is the mapping of a set of table
I have the following view:
CREATE VIEW as example
AS
SELECT col1 FROM table1 INNER JOIN table2 USING(col1);
Then when I use it:
SELECT a.col1, a.col2, a.col3 FROM table1 AS a INNER JOIN example
USING (col1);
Is the optimizer smart enough to figure out that it can join table1 directly to
table
I am using FB 1.5 and doing a delete from a large table using the
primary key as a reference from a sub select
delete from tableA where ID in (select ID from tableB where someval = 'x')
The subquery is fast and looks like it uses the index. But the plan for
the delete is (ID NATURAL) and take
On Mon, Sep 26, 2011 at 12:06 PM, firebirdsql firebird...@yahoo.com wrote:
I have the following view:
CREATE VIEW as example
AS
SELECT col1 FROM table1 INNER JOIN table2 USING(col1);
Then when I use it:
SELECT a.col1, a.col2, a.col3 FROM table1 AS a INNER JOIN example
USING (col1);
Is
