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
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
.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
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
-