im not understanding the index topic..i agree wht i asked was?i need clear information regarding indexes and its type where should we use them
Do some research in Books Online - there is information at different levels that might interest you (from "architecture" to T-SQL syntax). Only ask questions if you do not understand specific stuff - you're not in school here.[]
You need to read Books online first and then check the following articles.... http://www.sql-server-performance.com/articles/per/index_data_structures_p1.aspx http://msdn.microsoft.com/en-us/library/ms177443.aspx http://msdn.microsoft.com/en-us/library/aa174541(SQL.80).aspx
