Skip to main content
Database Administrators

Return to Question

added 104 characters in body
Source Link
Simon Verbeke
Simon Verbeke
  • 203
  • 2
  • 6

In another question they told me that the speed of a DBMS largely depends on the optimizations of your queries. Does anybody know good documents about this? At school I only learned the basics.

For example, a query to find a user with a password.

I would take this from a table that holds the personal information or just only username/password.

My query would look something like:

SELECT username, password
FROM tblUsers
WHERE username = foo

Is there any optimization to this? Or is it only in very large operations, like having a lot of JOINS with a large number of records?

EDIT: The above example is just that, an example. I'm looking for documents on Query optimization ;)

In another question they told me that the speed of a DBMS largely depends on the optimizations of your queries. Does anybody know good documents about this? At school I only learned the basics.

For example, a query to find a user with a password.

I would take this from a table that holds the personal information or just only username/password.

My query would look something like:

SELECT username, password
FROM tblUsers
WHERE username = foo

Is there any optimization to this? Or is it only in very large operations, like having a lot of JOINS with a large number of records?

In another question they told me that the speed of a DBMS largely depends on the optimizations of your queries. Does anybody know good documents about this? At school I only learned the basics.

For example, a query to find a user with a password.

I would take this from a table that holds the personal information or just only username/password.

My query would look something like:

SELECT username, password
FROM tblUsers
WHERE username = foo

Is there any optimization to this? Or is it only in very large operations, like having a lot of JOINS with a large number of records?

EDIT: The above example is just that, an example. I'm looking for documents on Query optimization ;)

Source Link
Simon Verbeke
Simon Verbeke
  • 203
  • 2
  • 6

Query optimization

In another question they told me that the speed of a DBMS largely depends on the optimizations of your queries. Does anybody know good documents about this? At school I only learned the basics.

For example, a query to find a user with a password.

I would take this from a table that holds the personal information or just only username/password.

My query would look something like:

SELECT username, password
FROM tblUsers
WHERE username = foo

Is there any optimization to this? Or is it only in very large operations, like having a lot of JOINS with a large number of records?