July 1, 2002 at 4:27 am
i am having one table having rows more than 1gb now when i trying to access the rows i an getting result very slow.
even i had indexed one field also.
pls suggest me the best solution what should i do.
vijay verma
vijay verma
July 3, 2002 at 3:03 am
do you have clustered index on it? if yes than did u recreated clustered index after loading data?
any field is having data type as text or image?
did u run dbcc updateusahe and checkdb?
if this wont work that give details about table data and indexes.....
Prakash
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
July 3, 2002 at 5:24 am
quote:
if this wont work that give details about table data and indexes.....
And the types of select queries -- are you using the index in the WHERE clause?
What does the SQL Query plan indicate with select statements?
Thomas Rushton
blog: https://thelonedba.wordpress.com
July 12, 2002 at 10:32 pm
Look at you execution plan in QA or use SET SHOWPLAN_TEXT ON and see what the query engine is deciding is the best access method. Sometimes it can be as simple as missing statistics.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply