Interested to Buy Any Domain ? << Click Here >> for more details...
what is the advantage of stored procedures, triggers and
indexing in mysql
- 1 Answers
- 4628 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is mysql and mysqli?
Can we create table in stored procedure?
Does mysql support nosql?
How to convert numeric values to character strings?
How to see the database architecture in MySQL??
How can you validate emails using a single query?
What are triggers in mysql?
How do I rename a table in mysql?
What is the data type for file in mysql?
Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T
How do I insert an image into mysql workbench?
What is the maximum number of records in mysql table?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
