• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 37. Database Basics > Performance Tuning Do's and Don'ts

Performance Tuning Do's and Don'ts

Both file server and RDBMS-type databases have internal structures that help to find data faster than sequentially reading every record in a table. An index is the most common structure. Advanced databases have many types of index schemes, each optimized for certain types of data or retrieval methods.

Over-indexing hurts performance, but a few basic guidelines apply. Keys to a table are automatically indexed. Generally, you should have an index on any column that is in a where clause of a query or is a foreign key or part of a join.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint