On 04/05/2011 06:26 AM, Adarsh Sharma wrote:
CREATE INDEX idx_svo2_id_dummy ON svo2 USING btree (doc_id,
clause_id, sentence_id);
or
CREATE INDEX idx_svo2_id_dummy ON svo2 USING btree (doc_id);
CREATE INDEX idx_svo2_id_dummy1 ON svo2 USING btree (clause_id);
CREATE INDEX idx_svo2_id_dumm
On Tue, Apr 5, 2011 at 3:56 PM, Adarsh Sharma wrote:
> Dear all,
>
> I want to clear my doubts regarding creating several single or a
> multi-column indexes.
> My table schema is :-
> CREATE TABLE svo2( svo_id bigint NOT NULL DEFAULT
> nextval('svo_svo_id_seq'::regclass), doc_id integer, sent
Dear all,
I want to clear my doubts regarding creating several single or a
multi-column indexes.
My table schema is :-
CREATE TABLE svo2( svo_id bigint NOT NULL DEFAULT
nextval('svo_svo_id_seq'::regclass), doc_id integer, sentence_id
integer, clause_id integer, negation integer, subject
