Answer Posted / kalai

1.Advsntsge of Stored Procedures:
================================
Stored Procedures are precompiled one.
it is the group of sql statements.
stored procedure like a application programming.
stored procedure is a fast one because it is already
precompiled.
stored procedure is the one is easy to maintain.

2.Advantage of Triggers:
========================
Triggers is a special kind of procedure.
the Main advantage of the trigger is automatic.
whenever the table affected by insert update or delete
query that time the triggers will implicitely call.

3.Advantage of Indexs:
======================
The Main advantage of the indexes is speed.
if the table having the indexes while selecting or
filtering the row(s) 0r columns(s) ,the execution time
very fast.
but, if you use the indexed table the insert update and
delete will be slow.

Does facebook still use mysql?

971

---

Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

1019

---

What is trigger in mysql with example?

968

---

What is indexing in mysql?

1018

---

What are the three types of queries?

955

---

What is pdo :: fetch_assoc?

948

---

What is pragma serially_reusable and why is it used?

899

---

What is row?

1140

---

What is text?

1016

---

What is the latest version of php and mysql?

1268

---

How to delete a column and add a new column to database

991

---

What's new in mysql 8?

1038

---

What is strict mode in mysql?

951

---

Does mysql use t sql?

1023

---

how to take mysql database backup?

1126

---