A select query over a large table runs very slow because of the growing number of entries in that table. What different measures could be taken to improve speed?

5 Answers  

---

Which is best pdo or mysqli?

0 Answers  

---

Is mysql same as mariadb?

0 Answers  

---

What are the differences between a primary key and foreign key?

0 Answers  

---

How do you create a new database in mysql?

0 Answers  

---

---

What is the storage engine for mysql?

0 Answers  

---

i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?

0 Answers  

---

How to show all records starting with the letters 'sonia' and the phone number '9876543210'

0 Answers  

---

What is regex in mysql?

0 Answers  

---

Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

0 Answers  

---

What is a mysql model?

0 Answers  

---

What is meant by mysqli?

0 Answers  

---