Hi Guest
MobileUser
HomePage
Jobs
WalkIn
Articles
Agile
DotNet
WebServices
Mathematics
OOPS
WEB
SharePoint
Java
DataBase
Artificial Intelligence
BigData
Android
XML
Agile
Software
SEO
Science Techonlogy
Repository Questions
PHP
Frameworks
Server
Testing
HR
Java
TPF
Tutorial
Tools
Test and Papers
Silverlight
Science Techonlogy
----- Select Country -----
----- Select Location -----
----- Select Category -----
:) Latest Topic
AJAX
VB.NET
SQL Query
UDDI
CLASS
JavaScript Questions
SharePoint Interview
SilverLight
WCF
general knowledge
ASP.NET
:) Hot Jobs
:) Latest Articles
Follow
How do we can optimize or increase the speed of MySQL select query?
Question Posted on 03 May 2022
Home
>>
DataBase
>>
MySQL
>>
How do we can optimize or increase the speed of MySQL select query?
How do we can optimize or increase the speed of MySQL select query?
Below are some point which will really improve or optimize the MySQL select query:-
(1)By using Proper Index in MySQL
(2)By using the LIMIT keyword in SQL statement
(3)By using Primary Key in MySQL
(4)One important point is Whenever we have huge no of updation or deletion happened in that table we use OPTIMIZE TABLE command. This will reduce the unused space.
0
0
Input Your Comments Or suggestions(If Any)
Name
Email
(optional)
Comments
Other Important Questions
Can we use "Order BY" in delete statement in MySQL Query?
Difference between char_length and Length in MySQL?
What are different tables and default database present in MySQL?
Way to clear screen in MySQL in Window operating system?
Who was started and owned MySQL?
Top Searches:
asp net questions
vb net questions
sql query
uddl questions
class
javascript Questions
sharepoint interview questions and concept
silverlight questions and concept
wcf questions
beans
general knowledge
ajax questions
PHP
|
Biztalk
|
Testing
|
SAP
|
HR
|
Privacy policy |
Terms and Conditions
| Blog
If the copyright of any questions or content or syntax belong to you email us we will remove that(info@crackyourinterview.com or crackyourinterview2018@gmail.com)
Home
About Us
GroupChat
Sitemap
Feedback
Contact us