An index can be created in a table to increase the performance of application and we can get the data more quickly and efficiently. Let’s see an example to illustrate this point suppose now we are reading book in that I need to check the information for dbmanagement to get this information I need to search each page of the book because I don’t know in which page that word
Showing posts with label Indexes. Show all posts
Showing posts with label Indexes. Show all posts
Using SQL Data Definition Language (DDL) to Create Data Tables and Other Database Objects
Using the CREATE TABLE Statement to Create Tables
Tables are the primary structures used to hold data in a
relational database. In a typical multi-user environment, the database
administrator (dba) creates the tables that serve as the data stores for the organization's data. Users normally create
their own temporary tables used to store data extracted from the main
organizational tables.
Benefits of Stored Procedures
| Benefit | Explanation of benefit |
|---|---|
| Modular programming | You can write a stored procedure once, then call it from multiple places in your application. |
Subscribe to:
Posts (Atom)