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.

Is mysql free download?

903

---

How to determine the location of the data directory?

1014

---

How do you select a table?

1014

---

How do I start mysql from command line?

1070

---

What is cast in mysql?

957

---

How to enter binary numbers in sql statements?

1010

---

Explain the difference between primary key and candidate key in mysql?

1016

---

Why myisam is faster than innodb?

995

---

What is mysql port?

1131

---

Write a query to find duplicate rows in table?

952

---

What is mysql_query?

910

---

What is the default port number of mysql?

993

---

What is longblob in mysql?

1022

---

What is the difference between sql and mysql and oracle?

937

---

What is clob in mysql

1013

---