About Me

My photo
MCTS FOR SQL SERVER 2008 DOT NET PROGRAMMING WEB DESIGNING

Friday, 21 October 2011

HOW TO CREATE INDEX IN SQL?

CREATE NONCLUSTERED INDEX IX_itemid--The word IX is only optional for simple recognization of index
    ON itemlist (itemid);

   
    /* indexes are just like indexes on the last page of your study text books.
    indexes in sql are most usefel objects in any database fro spped up the database performance
    */

No comments:

Post a Comment