adspace


How can I speed up sql query?

Answer Posted / Indrajeet Kumar

You can optimize SQL queries by using indexes, reducing the amount of data returned, and avoiding SELECT *. Additionally, consider normalizing your database to reduce redundancy.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is bcp? When does it used? : Sql dba

1065


define sql insert statement ? : Sql dba

1110


what are all the common sql function? : Sql dba

1142


how to escape special characters in sql statements? : Sql dba

1124


If a cursor is open, how can we find in a pl/sql block?

1252


Can delete statement be rollbacked?

1065


What is the best sql course?

1064


what is schema? : Sql dba

1164


Can we use distinct and group by together?

1147


Is primary key always clustered index?

1101


how many tables will create when we create table, what are they? : Sql dba

1156


Does group by remove duplicates?

1121


what is sql server agent? : Sql dba

1189


what are the advantages of sql ? : Sql dba

1154


Is primary key clustered index?

1028