what is the advantage of stored procedures, triggers and
indexing in mysql
Answer Posted / lijo
SP's Stored procedures in simple words is a complied SQL
stt. where there is no need for compiling it again on
successive calls.
Trigger is mechanism to handle insert/update.., like
operation happening in database.
Index are used for searching where searching a indexed data
takes less time while comparing with un-indexed.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can you tell how many values can set the function of mysql to consider?
What is longblob in mysql?
List the different types of normalization?
How do I switch users in mysql?
How to find the unique values if the value in the column is repeated?
What does blob mean in mysql?
How to concatenate two character strings?
Can you tell the difference between ereg_replace() and eregi_replace()?
Is mysql same as sql?
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
How many ways to get the current time?
What is difference between oracle and mysql?
What is tee command in mysql?
What are the difference between and myisam and innodb?
What is clob datatype?