|
View previous topic :: View next topic
|
| Author |
Message |
roopannamdhari
Warnings : 1
New User
Joined: 14 Sep 2006
Posts: 71
Location: Bangalore
|
|
|
|
Hi,
How many index we can create on a particular Table. Suppose I am having 1 table with 7 columns than what is the max Number of Index possible on that table.
Thanks & Regards,
Roopa |
|
| Back to top |
|
 |
ksk
Active User
.jpg)
Joined: 08 Jun 2006
Posts: 355
Location: New York
|
|
| Back to top |
|
|
kgumraj2
New User
.jpg)
Joined: 01 Aug 2007
Posts: 42
Location: Hyderabad
|
|
|
|
Hi,
Any combination will work. But more the index more the Time to excecute. |
|
| Back to top |
|
|
roopannamdhari
Warnings : 1
New User
Joined: 14 Sep 2006
Posts: 71
Location: Bangalore
|
|
|
|
| Thanks.... |
|
| Back to top |
|
|
agkshirsagar
Active Member
Joined: 27 Feb 2007
Posts: 691
Location: Earth
|
|
|
|
This link points to DB2 V9 on Z/oS limits. Last link posted is for Db2 Everyplace edition, I guess it is not applicable for other versions of Db2.
IBM does not say there is any limit on number of indexes in Db2 V9 for Z o/s. |
|
| Back to top |
|
|
Phrzby Phil
Senior Member
Joined: 31 Oct 2006
Posts: 1042
Location: Richmond, Virginia
|
|
|
|
I would think the more indexes, then the longer to INSERT or UPDATE, but not necessarily SELECT. I'd expect most SELECT's to be possibly faster.
If you INSERT/UPDATE rarely, but SELECT frequently - then go for it. |
|
| Back to top |
|
|
|
|
