Tables in one Database Vs Several Databases
,
18 Jun 2015
| 1 comment
In the process of setting standards at Enterprise level in our organization. I curious what are the advantages and disadvantages:
1. Hosting all the tables under one database against spreading across different/several physical Databases.
2. Is there any performance hit when tables are joined across different databases.
How to get PPI/PI/SI usecount
,
03 Apr 2015
| 3 comments
Hi,
Is it possible to get the below information any any DBC/Pdcrdata tables ?
1. if a PPI is defined for a table then how many times is it used by the queries during a sampling period ?
2. How many times queries use the PI/SI of the table in their where/join conditions ?
¿Alternatives to increase the performance of this query?
,
22 Jun 2012
| 9 comments
Hello,
I have several questions about the delay in execution of this query.
High Performance Select Statements
,
28 Jan 2012
| 2 comments
Hi,
I have a very large table which has a primary index (x, y). I am trying to perform a search on multiple areas; e.g. area 1 is located between x=1, y=1 and x=100, y=100. My aim is to retrieve the first available row for each searching area as fast as possible.
Comments and Queries discussed at Partner's 2011
,
10 Oct 2011
| 4 comments
I was lucky enough to be able to attend Partners in San Diego last week. As part of that, I did have an opportunity to speak a time or two and discussed a few performance issues.
I discussed swapping, SegIO Reads, and measuring I/O bandwidth but wasn't able to provide detail or queries, etc. at the time.
They are below.
check performance of a View
,
11 Apr 2011
few views in the semantic layer are taking forever to return any data. How should I analyse this issue to see why it is taking long time. Is there any list of steps that should be done in sequence to effectively analyse the performance issue.
Is there any teradata that can be used.
Thanks,
AM
How to gain performance in manipulating and querying huge tables ?
,
25 Mar 2010
| 2 comments
Hi every body,
I am working some very big tables (about 50 billions records). The table contains all transactions captured in any point of time (timestamp is used to store the transaction). It has some columns, including a varchar(250) contain the free text comment (but contain some codes in these free text). I have use Primary Partition Index based on the Rang_n Date extract from this timestamp, and defined some secondary indexes as well as join index on this big table. However, there is a request to do the following: