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 is msql?

914

---

how we will Show selected records sorted in an ascending (asc) or descending (desc).

932

---

Is mariadb better than mysql?

986

---

What are mysql queries?

878

---

What is latest version of mysql?

946

---

What is mysql database used for?

956

---

How to enter Characters as HEX Numbers?

953

---

How to execute mysql query in php?

860

---

What are the common mysql functions?

890

---

What is database migration in mysql?

952

---

Why we use mongodb instead of mysql?

923

---

what is the difference between gui testing and database testing? : Mysql dba

1012

---

How to Change a users password from unix shell.

1025

---

Where’s database data actually stored?

903

---

Define REGEXP?

1035

---