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
- 11690 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 happens if the update subquery returns multiple rows in ms sql server?
What is dknf in normalization form?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
between cast and convert which function would you prefer and why?
What is in place upgrade in sql server?
What are the steps to process a single select statement?
Explain about extended stored procedure?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
When columns are added to existing tables, what do they initially contain?
What are the hotfixes and patches in sql server?
What is the fillfactor concept in indexes?
What is the difference between function and stored procedure in sql server?
What is join query?
Can you import Microsoft Excel data to SSRS?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
