IA column analysis
IA column analysis
When we are running column analysis on a table it is taking long time(more than 3 to 4 hours)even though volume of data is less on table.Not able to figure it out the root cause and from where i have start to find the issue.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Column analysis should not use any indexes; basically it issues the query SELECT * FROM tablename against the database (or just the specified columns if relevant).
Sampling is performed within Information Analyzer.
The only time indexing might be useful is a virtual table in Information Analyzer that includes a WHERE clause.
Remote tables can be expected to deliver results more slowly than local ones; this is a network issue, not an Information Analyzer issue. It would not matter which client you used.
Sampling is performed within Information Analyzer.
The only time indexing might be useful is a virtual table in Information Analyzer that includes a WHERE clause.
Remote tables can be expected to deliver results more slowly than local ones; this is a network issue, not an Information Analyzer issue. It would not matter which client you used.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi,
You do it from the Column Analysis workspace.
Please see: https://www-01.ibm.com/support/knowledg ... ml?lang=en
You do it from the Column Analysis workspace.
Please see: https://www-01.ibm.com/support/knowledg ... ml?lang=en
Regards,
Robert
Robert
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You have to "create" the virtual table definition first - by specifying the columns and WHERE clause and giving it a name. Once you have saved this it will appear in the list of tables available for running Column Analysis (and, later, the other analyses).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.