Net Use * \\192.168.1.72\c$ /U:USER-PC\Administrator *
c: its drive name of other LAN machine which needs to map
You can apply Index to the columns that you use for searching, sorting, or grouping, join clauses [not columns you only display as output.]
More About Indexing :
indexes speed up retrievals but slow down inserts and deletes.as well as updates of values in the indexed columns.
Precaution needs to be take while indexing:
The more indexes inside the table ,the more changes need to be made, and the greater the average performance degradation