What Is An Index?

 

What Is An Index?

A SQL index is used to retrieve data from a database very fast. Indexing a table or view is, without a doubt, one of the best ways to improve the performance of queries and applications.

A SQL index is a quick lookup table for finding records users need to search frequently. An index is small, fast, and optimized for quick lookups. It is very useful for connecting relational tables and searching large tables.

SQL indexes are primarily a performance tool, so they really apply if a database gets large. SQL Server supports several types of indexes but one of the most common types is the clustered index. This type of index is automatically created with a primary key. 

Support Faryal's Cusine

Edit and Display Method

 

Difference Between Edit And Display Method

The display indicates that the method’s return value is to be displayed on a form or a report.
The value cannot be altered in the form or report.

Edit indicates that the method’s return type is to be used to provide information for a field that is used in a form. The value in the field can be edited.

Support Faryal's Cusine