What are the factors you will check for the performane
optimization for a database query?
Answer Posted / khalid moin
try to use function based indexes and use it when needed..
it will not be used unnecessorily.
use clustering concept while creating table it will make you
join operation fast if more join operation u r going to
perform on the tables
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to find Duplicate Records In table?
What is the use of commit?
how many clustered indexes can be created on a table? : Sql server database administration
What is store procedure? When do you use?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
Explain activity monitors
What are the different types of upgrades that can be performed in sql server?
How to get the definition of a view out of the sql server?
How do I partition a table in sql server?
What are the pre-defined functions in the sql server?
What are the types of normalization?
What are dml triggers and types of dml triggers?
What is tabulation?
What is a group function explain with an example?
write an SQL query to list the employees who joined in the month of January?