Re: [PERFORM] Index is not using

K P Manoj wrote: > Please find the details of table description > > test=# \d xxx >Table "public.xxx" > Column|Type | Modifiers > --+-+--- > crawler_id

Re: [PERFORM] Index is not using

Hi Albe, Thank you for your reply , Please find the details of table description test=# \d xxx Table "public.xxx" Column|Type | Modifiers --+-+--- crawler_id

Re: [PERFORM] Index is not using

K P Manoj wrote: > 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 || '.%'); > QUER

[PERFORM] Index is not using

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 -

Re: [PERFORM] index is not using?

On Tue, Feb 9, 2010 at 12:55 AM, AI Rumman wrote: > I have created a index > create index leadaddress_phone_idx on > leadaddress(regexp_replace((phone)::text, '[^0-9]*'::text, ''::text, > 'g'::text)); > > But the index is not using. like '%yada' isn't capable of using an index. If it's left anc

[PERFORM] index is not using?

I have created a index create index leadaddress_phone_idx on leadaddress(regexp_replace((phone)::text, '[^0-9]*'::text, ''::text, 'g'::text)); But the index is not using. explain select * from leadaddress where regexp_replace(phone,'[^0-9]*','','g') like '%2159438606';