What are the advantages of stored procedures, triggers,
indexes?
Answer Posted / manish jha
Triggers are automatic executable statement.
A stored procedure is a set of SQL commands that has been
compiled & stored on the database server.
Indexs hepls to execute queries fast.
| Is This Answer Correct ? | 20 Yes | 7 No |
Post New Answer View All Answers
What are the advantages of mysql in comparison to oracle?
Is mysql written in c?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
Is mysql free software?
What is datatype in mysql?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
What is striped backup
What is an index? How can an index be declared in mysql?
What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
What is the use of mysqli_fetch_array?
What is the difference between unix timestamp and mysql timestamp?
How do I update a variable in mysql?
Where’s database data actually stored? Is there a way to see the files which are stored?
What is horizontally scalable?
What is pdo connection?