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 convert a unicode strings to non-unicode strings?
List types of tables in SQL Azure?
How exceptions can be handled in sql server programming?
how to do partition in sqlserver
Does partitioning help performance?
What is order of B+tree?
How to create a ddl trigger using "create trigger" statements?
What is the difference between join and inner join?
How you can minimize the deadlock situation?
What stored by the model?
what are acid properties? : Sql server database administration
Explain triggers?
Do you know what is blocking?
What is sharding?
How to delete duplicate rows in sql server?