Re: Searching in varchar column having 100M records

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wed, Jul 17, 2019 at 4:04 AM mayank rupareliya <mayankjr03@xxxxxxxxx> wrote:

create table fields(user_id varchar(64), field varchar(64));

CREATE INDEX index_field ON public.fields USING btree (field);

Any suggestions for improvement?

Reduce the number of rows by constructing a relationally normalized data model.

David J.