What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
- 1 Answers
- 1301 Views
- I also Faced
- E-Mail Answers
Answer / Sachin Vishnoi
Advantages of using stored procedures:
1. Improved Performance: Stored procedures can be compiled and optimized by the database engine before execution.
2. Security: They help protect sensitive SQL code from unauthorized users.
3. Reduced Network Traffic: Since the procedure is stored on the server, only the results need to be sent over the network.nnDisadvantages:
1. Inflexibility: Once a stored procedure is created and deployed, it can't be easily changed or updated.
2. Learning Curve: Mastering stored procedures requires understanding of SQL and the specific database system being used.
| Is This Answer Correct ? | 0 Yes | 0 No |
what are the types of dimension tables
which automation tool is used in data warehouse testing?
What are modeling tools available in the market?
Explain what is ods (operation data source)?
What is data stream and data adaopter. Is it same are different? Explain?
What are the advantages and disadvantages of reporting directly against the database?
Explain ddl (data definition language)?
Explain degenerate dimension table?
How can we do data cleaning?
Write a short note on data warehousing & three-Tier Warehouse architecture in detail.
What needs to be done while starting the database?
Explain what are the various reporting tools in the market?
Teradata 
