What are the factors you will check for the performane
optimization for a database query?
- 7 Answers
- 10528 Views
- CarrizalSoft Technologies, DELL, SoftSol, I also Faced
- E-Mail Answers
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 get the query of a table in sql server?
Can you roll back the ddl statement in a trigger?
How to change parameter value inside the report?
What is the difference between row_number and dense_rank?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
what are acid properties? : Sql server database administration
What is collation sensitivity?
What are temporal tables in sql server 2016?
How can change procedure in sql server?
Explain the difference between primary keys and foreign keys?
Tell me what is difference between view and materialized view?
How to encrypt Strored Procedure in SQL SERVER?
Tell me what is the difference between locking and multi-versioning?
What is the difference between migration and upgradation in sql server?
What is field with example?
