Reputation
243
Top tag
Next privilege 250 Rep.
View close votes
Badges
1 4 10
Impact
~20k people reached

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
Apr
20
awarded  Famous Question
Mar
25
awarded  Popular Question
Feb
25
awarded  Notable Question
Aug
20
awarded  Nice Question
Jul
2
awarded  Curious
Jan
28
awarded  Notable Question
Jun
14
awarded  Popular Question
Apr
10
awarded  Yearling
Dec
21
awarded  Popular Question
Dec
4
awarded  Notable Question
Apr
10
awarded  Popular Question
Feb
10
awarded  Supporter
Jan
25
asked In DB2, how can I disable NLJOIN?
Dec
30
accepted DB2 equivalent for MySQL's DROP .. IF EXISTS
Dec
21
asked DB2 equivalent for MySQL's DROP .. IF EXISTS
Nov
23
comment In DB2, what are the alternative ways of evaluating an index's (or several indexes) benefit?
Thanks a lot. In the same spirit of question dba.stackexchange.com/q/56/2660 I'd like to know, once I have a set of recommended indexes, which ones are necessary. Quoting from that question: "I am reluctant to take the plunge and blindly add the recommended indexes... I am looking for some advice on how to determine whether the recommendations are necessary or not". I'm also interested in this. In other words, how can I make sense about the recommendations besides looking at the output of the index advisor?
Nov
22
awarded  Editor
Nov
22
comment In DB2, what are the alternative ways of evaluating an index's (or several indexes) benefit?
thanks, modified it to refer to db2
Nov
22
revised In DB2, what are the alternative ways of evaluating an index's (or several indexes) benefit?
specifying a concrete platform
Nov
21
comment In DB2, what are the alternative ways of evaluating an index's (or several indexes) benefit?
@NickChammas I see. Thanks for the link. Should I specify a concrete DBMS implementation then? Or do you think I can leave the question open?