[PERFORM] Query performance

2013-06-13 Thread K P Manoj
Hi All One of my query treating performance issue on my production server. Once i run query on my parent table with specific condition(hard coded value) its uses only proper child table and its index on explain plan , but once i am using table conditions (instead of hard coded value), query pla

[PERFORM] K P Manoj has invited you to open a Google mail account

2013-06-13 Thread K P Manoj
I've been using Gmail and thought you might like to try it out. Here's an invitation to create an account. You're Invited to Gmail! K P Manoj has invited you to open a Gmail account. Gmail is Google's free email service, built on the idea that email can be intuitive

Re: [PERFORM] Index is not using

2012-11-12 Thread K P Manoj
.24601.62 rows=1442062 width=18) (5 rows) My question was any chance to use query planner with above index ? or i want to change the query ? Regards Manoj K P On Mon, Nov 12, 2012 at 2:01 PM, Albe Laurenz wrote: > K P Manoj wrote: > > I am facing query performance in one of my testing server

[PERFORM] Index is not using

2012-11-11 Thread K P Manoj
Hi All I am facing query performance in one of my testing server. How i can create index with table column name ? EXPLAIN select xxx.* from xxx xxx where exists (select 1 from tmp where mdc_domain_reverse like xxx.reverse_pd || '.%'); QUERY PLAN -