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
What is command parameter in ssrs?
Why union all is faster than union?
How to display a past time in days, hours and minutes?
Do you know what are different types of replication in sql server?
How to create a user to access a database in ms sql server using "create user" statements?
Explain primary key in sql server?
How to list all stored procedures in the current database using ms sql server?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What do you mean by recursive stored procedure?
What are the advantages of using cte?
Are null values the same as that of zero or a blank space?
If a table does not have a unique index, can a cursor be opened on it?
What is logshipping and its purpose?
What is the significance of null value and why should we avoid permitting null values?
What are horizontal and vertical scaling?