Answer Posted / Ahmad Ashraf
Types of optimization in SQL include query optimization, database design optimization, physical database optimization, and application-level optimization. Each type focuses on a different aspect to improve overall performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I remove duplicates in two columns?
what is bcp? When does it used? : Sql dba
what is sql server agent? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Do we need to rebuild index after truncate?
Can we rollback truncate?
Is inner join faster than left join?
define sql insert statement ? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
What is the best sql course?
Can we use distinct and group by together?
what is collation? : Sql dba
Does group by remove duplicates?
What is the current version of postgresql?
