SQL by Joe Gakenheimer
This part of my site I explain a little bit about SQL and database development. For some odd reason, during interviews I am always asked the question:
What is an Index?-Indices are created in an existing table to locate rows more quickly and efficiently. It is possible to create an index on one or more columns of a table, and each index is given a name. The users cannot see the indexes, they are just used to speed up queries.
Note: Updating a table containing indexes takes more time than updating a table without, this is because the indexes also need an update. So, it is a good idea to create indexes only on columns that are often used for a search.
The links to the related subject can be found below:
What is Normalization?
- Normalization
- First Normal Form
- Second Normal Form
- Third Normal Form
- Four and Fifth Normal Form
- INNER JOIN
- OUTER JOIN
- Stored Procedure
- Stored Query
- SQL Server 2000 versus Access 2000
home | me | faq | resume | portfolio | pics | site | asp | asp.net | java | javascript | sql | xml
algorithms | dbms | html | j2ee | mis | networking | os | se | more...
algorithms | dbms | html | j2ee | mis | networking | os | se | more...
Updated: May. 1, 2005; Joe Gakenheimer
© joegakenheimer.com