Database Reference
In-Depth Information
Figure 10-9:
Stored Procedures query.
You can see it in the Object Explorer window by refreshing the Stored Procedures folder.
You can alter a procedure by right-clicking the procedure and selecting Modify. Make
the changes you need and then click Execute.
Tip
Indexing and Performance Considerations
Analytics systems performance has two aspects: load performance and query performance. Your
objective when building the system should be to optimize both. We delve into the factors involved in
achieving that goal in this section.
Understanding index types
Indexing is a very important factor in improving database performance. Indexing helps the database
get to the data faster when you're retrieving data in your query. The types of indexes in SQL Server
that are important for an analytics system are
Search WWH ::
Custom Search