db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Oscar Bonilla (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-5138) Why can not create session indexes, session unique indexes and identity columns in temporary session tables
Date Thu, 17 Mar 2011 02:35:29 GMT
Why can not create session indexes, session unique indexes and identity columns in temporary
session tables
-----------------------------------------------------------------------------------------------------------

                 Key: DERBY-5138
                 URL: https://issues.apache.org/jira/browse/DERBY-5138
             Project: Derby
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 10.7.1.1
         Environment: windows, linux
            Reporter: Oscar Bonilla


I am a senior programmer in sybase (transact sql) and Oracle. I had to convert a lot of programs
to work in DB2. There are many processes that require a lot of rows in temporary tables that
needs join together, and they expends much time to execute without indexes. I have to transform
the logic to do that with permanent tables with indexes those I have to drop after the process.
Now, DB2 can do "create unique index SESSION.xx_I01 on SESSION xx" and this resolve my problem
with the efficienty of the processes. In another hand, I do not have any problem to use "GENERATED
ALWAYS AS IDENTITY" in a temporary session table in DB2.  With this 2 issues it is imposible
to migrate all the systems to work with Derby. Thank.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message