[
https://issues.apache.org/jira/browse/DERBY-5138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mamta A. Satoor updated DERBY-5138:
-----------------------------------
Labels: derby_triage10_10 features (was: features)
> 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
> Labels: derby_triage10_10, features
> Attachments: DB2 script.txt
>
>
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
