Question

1. Review Books-online for details about indexes (Creating Indexes - Database Engine). 2. Open SSMS, then databases, then your database, expand a table, and right mouse indexes. 3. Select ‘New Index”.

Answer 1

Indexes are a special category lookup tables that rare used for data base search engine can sped up for data retrieval.
An index is a schema object that contains an entry for each value that appears in the indexed columns of the table and provides
direct fast access to rows.

Indexes are similar to pointers.index is similar to book index which we have generally in the first or last of a book.

To create an index
CREATE INDEX index_name ON table_name;

Indexes are different types - single column, unique, composite and Implicit indexes.

Here is an example of creating an index for Books data base.

Books is database
book is table with attributes (bookid,bookname, author, editionnumber, publisher, price) *bookid - primary key

CREATE UNIQUE INDEX idx_books ON book (bookname, price);

The SQL statement above creates an index named "idx_books" on the "bookname, price" columns in the "book" table