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
- 11649 Views
- CarrizalSoft Technologies, DELL, SoftSol, I also Faced
- E-Mail Answers
Answer Posted / sravan kumar vemuri
The most important option to increase the query performance
is to create index on the table.
First one should concerntrate on the columns used in the
where cluase.
But indexes can hit the performance for insert queries. So
before giving an insert query, better to remove the index
and then to recreate the index.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to connect of datebase with sql express.?
What are the three different part of rdl file explain them?
what is an extended stored procedure? : Sql server database administration
How many servers can we create in a single subscription?
What is normalization 1nf 2nf 3nf?
How many tables can be joined in SQL Server?
What are the different types of columns types constraints in the sql server?
Why main is user defined function?
Why I can not enter 0.001 second in date and time literals in ms sql server?
what is the system function to get current user's user id? : Sql server database administration
Explain the use of containers in ssis?
Is sql server is free?
What is the difference between getdate and sysdatetime?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is a trigger what are the advantages of trigger?
