One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

TCS,

When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

IBM,

OPTIMIZATION OF SP,CURSOR,TRIGGERS

what's query optimization and without use of IN AND Exist can we get another way data from query

what is the difference b/w heuristic and optimizer in apo snp?

How we will implement Pushdown Optimization and Types in Informatica with better examples

TCS,

 What are the various ways to optimize performance for any and all components of the PeopleSoft application?

Can you optimize the website which has pages in millions?

If you only had an hour (in one shot) to spend on WSO [web site optimization] for a given site each year, what would you do for that hour, and why?

Have you seen UIEs research on users perceptions of download speed? Does not that really debunk the notion that code/graphic optimization improves usability? Is not it really all about scent of information and users "feeling" like they are consistently making progress?

How can the weblog be optimized to load better but also show first-timers that work is being done?

What is the most common problem to be solved when optimizing web sites?

What major web sites do the best job of optimization?

There is software that assists and, in some cases, automates the accessibility process. Is there any software that does the same for web site optimization?

Do you feel that information architecture (in this case I mean the categorization of web pages for find ability) can have an effect on site optimization? I suppose I'm asking if things like intuitive URLs and labels can reduce the need for extra context on a page. How would you separate site optimization and usability/IA?