Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors you will check for the performane
optimization for a database query?
- 7 Answers
- 11914 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
What is the size of transaction log file?
What are the differences between lost updates and uncommitted dependencies?
How to link tables in sql server?
What is the Difference Between Primary and Foreign Key?
What is a covered index?
What is an execution plan? How would you view the execution plan?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
How to insert multiple rows with one insert statement in ms sql server?
How to list all objects in a given schema?
What are .mdf files?
What are the kinds of subquery?
What is cursor in ms sql server?
Differentiate between mongodb vs. Sql server?
which table keeps the locking information? : Sql server administration
Explain isolation levels that sql server supports?
