Text column in select query

I have a text column table and that contains 3000 records but when I try to
use top 10 query and include text column it take 10 minutes and when I
remove the text column from the select query it takes a second, any idea how
we can speed up the query if I include text column in my list.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 3rd April 13:27 rogers External User Posts: 1	Text column in select query I have a text column table and that contains 3000 records but when I try to use top 10 query and include text column it take 10 minutes and when I remove the text column from the select query it takes a second, any idea how we can speed up the query if I include text column in my list.