467,154 Members | 946 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,154 developers. It's quick & easy.

That works faster in DB2 for creation of an index?

HELLO all

That works faster in DB2 for creation of an index:
CREATE INDEX
or
Alter Table tab ADD INDEX
for Import?

Thanks.

Aug 23 '07 #1
  • viewed: 1584
Share:
1 Reply
Pi*************@gmail.com wrote:
That works faster in DB2 for creation of an index:
CREATE INDEX
or
Alter Table tab ADD INDEX
for Import?
The first one works, the second doesn't because it is already syntactically
incorrect.

You can add constraints to a table and unique constraints (primary keys are
just unique constraints) use a unique index under the covers for their
implementation. Aside from that, you have the CREATE INDEX statement to
create indexes.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Aug 23 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Aaron | last post: by
5 posts views Thread by Tompa | last post: by
3 posts views Thread by eric.nave@gmail.com | last post: by
8 posts views Thread by dbamota | last post: by
6 posts views Thread by Steven Wolf | last post: by
2 posts views Thread by db2udbgirl | last post: by
17 posts views Thread by onkar | last post: by
12 posts views Thread by vunet.us@gmail.com | last post: by
1 post views Thread by Picaso.Leonardo@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.