Issue during importing of Oracle metadata when the schema is partitioned
------------------------------------------------------------------------
Key: TEIIDDES-935
URL:
https://issues.jboss.org/browse/TEIIDDES-935
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Reporter: Debbie Steigner
The Table is BIG ! - The Oracle table that we're importing is partitioned by date with
5 million rows per day and 2 years worth of data.
The problem is that it takes longer than 2 hours because it issues an ANALYSE table
command.
Would it be possible to create an option (perhaps a checkbox) that would allow the meta
data to be created quiclky and defer the ANALYSE to runtime?
create an option (perhaps a checkbox) on Import from JDBC that would allow the metadata to
be created quickly and defer the ANALYSE to runtime. Also, it was indicated that the
ANALYSE call is an old Oracle command, that there is a newer command. Also, consider
running the stats only only the requested partition.
--
This message is automatically generated by JIRA.
For more information on JIRA, see:
http://www.atlassian.com/software/jira