[MonetDB-users] add a unique constraint, need to create index? - users-list - monetdb.org

newer
[MonetDB-users] Dump schema w/...

[MonetDB-users] add a unique constraint, need to create index?

older
[MonetDB-users] Large XML...

Mark Bucciarelli

4 Oct 2010 4 Oct '10

4:19 p.m.

Hi, I added a unique constraint on two fields, and noticed there was not an index created on those two fields. Do I need to do a CREATE INDEX or is it implicit? I will be using those two fields a lot in WHERE clauses. Thanks, m

Reply

Sign in to reply online Use email software

Show replies by date

Mark Bucciarelli

4 Oct 4 Oct

6 p.m.

On Mon, Oct 4, 2010 at 10:19 AM, Mark Bucciarelli <mkbucc@gmail.com> wrote:

Do I need to do a CREATE INDEX or is it implicit?

I figured this out. The answer is no.

From sqlmanual:

Index selection, creation and maintenance is automatic. Thanks, m

Reply

Sign in to reply online Use email software

5347

Age (days ago)

5347

Last active (days ago)

Download

1 comments

1 participants

tags

participants (1)

Mark Bucciarelli