On TechRepublic: Five super-secret features in Windows 7
BNET Business Network:
BNET
TechRepublic
ZDNet

FREE Registration is required

Overview:

Here is a not-so-uncommon scenario: a query is running slowly. Upon investigation, one determines the reason to be a full-table scan and a possible solution to be an index to help speed up the query. As part of this performance-improvement process, programmers may have to make several changes in the database, including using indexes and statistics, converting to different index types, changing optimizer compatibility, and modifying an initialization parameter. This paper demonstrates how to use SQL performance analyzer to gauge the overall impact of creating an index on the STORE_ID column in a table called TRANS and then refreshing the statistics on the table and the index.

(Is this item miscategorized? Does it need more tags? Let us know.)

Format:HTML
Date:Mar 2008
Pages:6

People who downloaded this item also downloaded

White Paper Delivering Affordable Information Management Functionality: Oracle Database Standard Edition One
Book Chapters Oracle in a Nutshell: Performance
White Paper Tuning Your View Objects
White Paper Oracle Performance Tools: Reduce Your IT Infrastructure Investment
Book Chapters Use these four Registry tweaks to accelerate Windows XP

Top results from Programming Languages

White Paper Surviving and Thriving in the Customer-Driven Age
White Paper Designing High Availability for Internet Information Services
White Paper Citizants: Bringing IT In-House
White Paper Supporting Employees Anytime, Anywhere
White Paper The Pursuit of a Standardized Solution for Secure Enterprise RBAC

» View all Programming Languages listings

advertisement

White Papers, Webcasts, and Resources

Featured Training Courses

advertisement

SmartPlanet

Click Here

Returning users: Log In Here!

Already registered on BNET, TechRepublic, or ZDNet? Simply log in.

Free Membership: Sign Up Now!

Sign up for a free membership today and get instant and unlimited access to one of the largest databases of white papers, webcasts, and casestudies anywhere. Your FREE membership allows you to:

  • Download an unlimited amount of content, including classic and current white papers, case studies, webcasts and more
  • Track content on your chosen topics of interest
  • Receive targeted email alerts when your favorite content is added
  • Save content for future reading
  • Receive our member newsletter

When you register to access this library, you allow us to share your information with companies that produce products or services featured in the library--so that such companies may contact you with information and offers regarding their products and services. This enables us to keep the library a free service. As a library registrant, you will receive a complimentary subscription to the ZDNet white paper newsletter and e-mail Must-Read News Alerts. You can unsubscribe from these at any time. By clicking the Sign up button, you indicate that you agree to our Terms and Conditions and have read and understand our Privacy Policy (updated).