LYCOS RETRIEVER 
Index: Index Tuning
built 127 days ago
The most important output from the Index Tuning Wizard is a set of recommended indexes. The Index Recommendations dialog box displays the list of these indexes, indicating the assigned index name, the table or view on which the index is defined, the order and collation (ASC or DESC) of columns in the index, whether the index is clustered, and whether the index exists. The Index Recommendations dialog box ... displays which indexes, if any, were recommended to be dropped by the Index Tuning Wizard. The wizard also produces an estimate of the expected improvement in the execution time of the workload compared to the existing configuration. The Index Tuning Wizard uses the optimizer component of the query processor to project this estimate. However, because the optimizer's projection is based on statistical information, the actual change in performance may be different from the projected estimate.
Source:
The CBOE NASDAQ-100 BuyWrite IndexSM is a benchmark index that measures the performance of a theoretical portfolio that sells NASDAQ-100 Index call options, against a portfolio of the stocks included in the NASDAQ-100 Index. For further details, please visit www.cboe.com/bxn.
Source:
DETROIT, Jan. 9 /PRNewswire-FirstCall/ -- The Michigan Business Activity Index compiled by Comerica Bank fell 2 points in November to 102, reversing the 2 point rise in October. Over the first eleven months of 2007, the index has averaged 103.8, down 0.5 from the average for all of 2006.
Source:
DETROIT, Oct. 26 /PRNewswire-FirstCall/ -- The Michigan Business Activity Index compiled by Comerica Bank fell 5 points in September to 102 after rising 3 points in the previous month. Over the first nine months of 2007, the index has averaged 104, essentially the same as the average for all of 2006.
Source:
The Index Tuning Wizard can be started from SQL Server Enterprise Manager. On the Tools menu, select Wizards, and then select Management. The Index Tuning Wizard is one of the wizards in the Management group. Alternatively, it can be started from SQL Profiler on the Tools tab of the Profiler menu. After the wizard obtains the necessary user input on required parameters, it carefully begins searching the possible configurations. If the search for the index configurations is terminated during this time, the wizard returns the best available configuration that has been considered ... far.
Source:
Two versions of the Index were calculated - a price return index and a total return index. The price return index is calculated without regard to cash dividends. The total return index reinvests cash dividends. Both usually reinvest extraordinary cash distributions. The BetterInvesting 100 Index is an equal-dollar weighted index.
Source:
MORE ABOUT
Index Tuning