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.

What are queries used for?

954

---

How do I disconnect mysql workbench?

1068

---

How do you create a new database in mysql?

917

---

Does mysql case matter?

911

---

What are stored procedures and functions?

905

---

Is mysql workbench a dbms?

1012

---

How to dump one database for backup.

943

---

How can I see all mysql databases?

894

---

Why do gaps in sequences occur?

958

---

What is a deterministic function?

1073

---

Is mysql free software?

971

---

What is mysql uuid?

926

---

What is heap table in mysql?

973

---

What is sharding in mysql?

972

---

What is database engine in mysql?

941

---