iam running a website ,its a jobsite
with only 200mb of sqlserver space,
no entripise manager connection allowed, only a web based interface just to create tables,drop,edit and to run sql queries
iam using that space to store job postings.
iam doing a search on ntext field which is jobdescription
where jobdescription like '%vb.net,asp.net%'
that sql query execution takes time
iam planning to make another dummy table, where job postings will be done, then i will extract data from that particular table to mainjobpostings table on a particular time
iam planing to index jobdescription field, which is ntext
is it the proper idea to do so, how can i speed up the sql queries which are for job search ?
any ideas and help will be appreciated, iam confused about speeding up sql queries
can i index jobdescription field ? for speed
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]