|
View previous topic :: View next topic
|
| Author |
Message |
ilakkia
Warnings : 1
New User
Joined: 17 May 2008
Posts: 28
Location: chennai
|
|
|
|
| How does DB2 create an Index automatically for a column? |
|
| Back to top |
|
 |
ashimer
Active Member
Joined: 13 Feb 2004
Posts: 551
Location: Bangalore
|
|
|
|
ilakkia,
some indexes are created implicitly to provide support for a table's definition (for example, to provide support for a primary key), but normally indexes are typically created explicitly using CREATE INDEX command ... |
|
| Back to top |
|
|
stodolas
Active Member
Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin
|
|
|
|
| A table doesn't have to have a primary key. Therefore a table can be defined without any indexes at all. That would force most statements to execute a full table scan. |
|
| Back to top |
|
|
|
|
