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 ??
Having multiple indexes on a table ???
Moderators: Kalicharan, Moderator Group
Having multiple indexes on a table ???
SONA KASI
- dbzTHEdinosauer
- Moderator
- Posts: 981
- Joined: Mon Oct 02, 2006 8:31 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.
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.
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
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.
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
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
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page