5

has this in the tag excerpt:

In the context of a database, optimisation refers to the process of the query optimiser selecting an efficient physical execution plan.

However, there is another tag, which is quite similar:

Query optimization is a function of many relational database management systems. The query optimizer attempts to find an efficient way to execute a given query by considering the possible query plans.

I proposed a synonym be created to point at - however the point was raised in chat that perhaps the two tags should be different. I agree with that point.

has 510 questions; these questions should likely be retagged with

The tag wiki for needs to be modified to be more generic; and perhaps the tag excerpt should guide users towards the tag for those types of questions.

Thoughts?

4

I would prefer server-optimization as the tag for server related issues. I prefer this over hardware-optimization since it focuses on the server environment overall rather than on the hardware in itself.

This focuses on systemic problems in the server environment, which would also include such things as network through-put, virtualization problems, the underlying server hardware, SAN behavior, and so forth.

I do agree with Jack Douglas and Paul White that optimization means query-optimization to most of the people most of the time. And that is fine.

5

I agree (510 questions) and (82) should be synonyms, as Jack suggests.

But, they should be used only for questions about the operation of the query optimizer/planner component, in line with the current wiki excerpt and description.

The word optimization is often used (especially colloquially or by beginners) when the intended meaning is closer to performance improvement. For those questions, the more popular (1534) or tags (835) may be more appropriate.

Though it might mean fighting a losing semantic battle, this answer suggests:

  • should be reserved for the query optimizer/planner component.
  • and related tags should be used for questions about improving performance.
  • New tags about improving performance should use the word "performance" rather than "optimization".

The existing and wikis should be amended to reflect this distinction, and guide people to the correct tag.

5

I'm not sure that optimization should always be shorthand for query-optimization - there is a significant amount of DBA work on many other sorts from hardware, storage, block sizes through indexing/MVs/etc as well.

I suggest is a synonym for rather than the other way round, and then other tags such as , or whatever can exist on their own if and when they are justified — eg this question isn't about query-optimization.

We could just have a generic to cover all optimization that doesn't fit in ?

2

I suspect optimization is going to be the general-case for queries, and so does not need specification. I feel like or makes more sense over as 90% of dba optimization is around queries, no?

I'm not saying we don't need to know about, for example, disk layout optimization. I'm just saying it's the outlier, whereas query optimization is the "default"

4

I agree the more generic should could be about optimal server/db settings, optimizing your disc system, or any number of other things. I think they should be seperate and have the wiki updates.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .