[MonetDB-users] add a unique constraint, need to create index?
4 Oct
2010
4 Oct
'10
2: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
4 Oct
4 Oct
4 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
5000
Age (days ago)
5000
Last active (days ago)
1 comments
1 participants
participants (1)
-
Mark Bucciarelli