Tags for database performance
Tables in one Database Vs Several Databases
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.  
database performance
How to get PPI/PI/SI usecount
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 ?
database performance physical design
¿Alternatives to increase the performance of this query?
Hello, I have several questions about the delay in execution of this query.
database performance join index cost of query
High Performance Select Statements
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.
database performance multi-statement requests select
Comments and Queries discussed at Partner's 2011
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.
queries database performance analysis swapping i/o bandwidth
check performance of a View
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
database performance
How to gain performance in manipulating and querying huge tables ?
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:
sql database performance huge table