Hi All, on an almost new and empty TD express instance queries against dbc.IndexV view take an unexpected long time, for example:
Normally, queries against dbc views returns result qucikly. 7 mins is a big time. Which version of TD you are using.
How much time it takes when you run query without any WHERE clause.
I think the issue would be with UPPER clause in where , the queries would run slow by using this
try without using upper (databasename). it is not required, because the column is not case specific.
Thanks all for your responses so far.
This is a strange behavior and must be frustrating.
Are you the only one facing this issue or any one else is facing the same issue? Has the DBA applied some TASM settings which might be putting your queries in a low priority workgroup or something?
also without UPPER does not improve the query runtime
SELECT IndexName,ColumnName FROM DBC.IndicesX WHERE IndexName is not NULL and TableName='order_fact' and DatabaseName='SASORION' order by ColumnPosition 0:08:05.710000
I get a similar problem on a Teradata Version 13.10 VM.
Have you managed to find out what the problem is?
My VM is hosted in Win 7 64-bit workstation.
2 Gb Ram and 2 Processors are assigned to the VM.
I can run the query on a Version 14.00 VM and it completes in a couple of seconds.