240 reputation
39
bio website cs.ucsc.edu/~ivo
location Santa Cruz, CA
age 31
visits member for 3 years, 3 months
seen Sep 25 '12 at 2:21

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?
Nov
19
comment In DB2, what are the alternative ways of evaluating an index's (or several indexes) benefit?
Yes, I'd like to know what are the options out there, regardless of the underlaying DBMS. As you mention, DMVs are one alternative for SQLServer. Other people may be using the hypothetical index feature of SQL Server. I'm trying to define the work-flows that people follow in this kind of situation. Maybe my question is too generic, in which case I could create one for each DMBS
Nov
19
asked In DB2, what are the alternative ways of evaluating an index's (or several indexes) benefit?
Jun
21
asked From where does the MySQL Query Optimizer read index statistics?