0 - 7 of 7 tags for database performance

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.

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 ?


I have several questions about the delay in execution of this query.


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.

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.

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.


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: