hello friends i have a table which has 2 lacs records only and 40 colms (one have images) bt wen i run select query, it takes around 15 mins to come out 2 lacs record. wat is the problem want to knw. it has clusterd index, and fulltext index also, want to improve the performnce. thanx sachin
Well, you mention having a column with images ... Say your table has columns col1, col2 and colimage. Compare the response time for these two queries: SELECT t.col1, t.col2, t.colimage FROM MyTable t SELECT t.col1, t.col2 FROM MyTable t
So what kind of query tool / client application are you using? And does the table have a primary key?