Indexing

Hi!!
I dont know if this is the correct forum for this or not, but still...
Actually i wanted to know some details about SQl's Indexing services.

I found this link on my hosters help pages :

You need to use SQL Query Analyzer tool for this.

This will enable full-text indexing for the current database:
exec sp_fulltext_database 'enable'

This creates a catalog:
exec sp_fulltext_catalog 'catalogname', 'create'

This enables indexing of a table:
exec sp_fulltext_table 'tablename', 'create',
'catalogname', 'indexname'

This adds a column to an index:
exec sp_fulltext_column 'tablename', 'columnname', 'add'

This activates fulltext on a table:
exec sp_fulltext_table 'tablename', 'activate'

These two enable automatic filling of the full-text index when changes occur to a table:
exec sp_fulltext_table 'tablename',
'start_change_tracking'
exec sp_fulltext_table 'tablename',
'start_background_updateindex'

From the above i get that i need to set up my database for indexing then make a catalog and then add an index of a table to this catalog. Can anyone point any good tutorials for using this is the proper way so that performance is not affected and tells me details on updating indexes etc(esp using some criterias). Moreover does indexing columns lower the performance? Is there a workaround? I am completely new to this.

Try these:
http://www.sqlteam.com/item.asp?ItemID=114
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_fullad_3bs2.asp
http://developer.com/db/article.php/3446891