Having multiple indexes on a table ???

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
sonakasi
Member
Posts: 20
Joined: Wed Nov 09, 2011 9:09 am
Location: India

Having multiple indexes on a table ???

Post by sonakasi » Thu Dec 29, 2011 1:56 pm

Hi all,

In our project, we have a table, which is having too many index and I think having too many index will affect performance.
Can some one explain if this right and the reason ??
SONA KASI

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Thu Dec 29, 2011 3:37 pm

you can not make blanket statements like that and expect them to have any meaning without qualification.

of course an index requires resources.

but if a business need exists for that index, then it must be implemented in a manner
that does not affect the business throughput.

the art of programming does not end with the finding of 'problems'
that is where the art starts: fixing the problem.
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Fri Dec 30, 2011 10:30 am

Why does someone believe there are "too many indesex"?

I am not aware of any document that says what is ok and what is too many.

As with most things, "it depends". Again, if there is some specific question, please post the question (which would need lots of suppoprting detail info) and possibly someone will have a suggestion.
Have a good one

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others