Skip to main content

Index in the database

 Index

Large books have indexes or indexes at the end to facilitate the search for various topics. Through it, it is known that a topic has been discussed on some page of that book. In the case of database also there is system of such index to find various data quickly. Such indexes increase the performance of searching for any information in the database. Simply put, an index is a pointer to data in a table. The created index is stored in a different location from that table. The main purpose of the index is to speed up data retrieval from the database. Indexes can be created or deleted without changing the data. However, queries may take longer if an index is deleted. Keep in mind that indexes occupy physical space and in some cases may be larger than the original data table. Databases need to create indexes to increase query performance. Indexes can be created during table creation or later. The create index statement creates an index for a column in a table. However, it should be remembered that the name and syntax of this command may be different depending on the database system. However, most relational database systems use the create index statement to create indexes. Its syntax is as follows:

Create index index_name on table_name

Labels:

Comments

Post a Comment

Popular posts from this blog

What should the processor look at?

The things that we all should keep an eye on are the processor or not; 1. Clock speed 2. Number of course 3. cache memory 4. FBS 1. Clock Speed: It is also called GH2. All processors are written on. Clock speed means how fast your computer can work. That's what this signal means. The speed of the processor is known through this clock speed, how fast the calculation can be done. 2. Number of Cores: The more cores the processor has, the faster the processor can work. If I give an example to explain the matter, I hope you can understand it very easily. Suppose if a person had many hands, then he could do many things at the same time. That is, if we go to the market and buy a smartphone, then we will see what the configurations of the phone are. If we look closely at the configuration of the smartphone, we will see that Dual Core Processor, Quad Core Processor, Octa core processor, Hexa core processor, Deca core processor. This means that the dual core processor has two arms or cores, ...
Post a Comment
Read more

How to create a google account from a Android mobile?

 I don't believe a long introduction. I don’t want to bore you.  Today I will teach how to create a google account very flexibly from an android device.  Firstly open a browser like Opera, Firefox, Google Chrome or any other it doesn't matter in that and then type create a Gmail account or  click here After clicking here then click on  create an account  option. Write here your first name and last name exactly. Then write an email address uniquely which did not use in the network or google database. After completing the write a unique email address subsequently you will write a password like  @hga34#@ !. This password format is very effective and efficient against brute force or any other intelligence attack. Now click on the next button  Select your country from here      Enter your mobile number in the orange colour selected blank field. Now enter a recovery email address in the selected field. Anytime if your email address passwo...
Post a Comment
Read more

What is transmission media? Introduction to different types of data transmission cables

Transmission media: When a PC communicates or wants to communicate with another PC, it has to take the help of some transmission media. The most commonly used media in the network are twisted pair cable, coaxial cable, fiber optic cable. Nowadays, the use of optical fiber is increasing greatly. Radio wave, microwave and infrared technologies are prominent among wireless media. Among these mediums, optical fiber has the highest data transfer speed. The type of medium used in a network depends on the type and location of that network. The connection system for exchanging information between the sender and the remote receiving end is called a channel. The means or methods used to implement the channel are called media. such as-- (i) Cable or wire. (ii) Common telephone lines. (ii) Radio waves. (iv) Microwave. (v) Geo-satellite systems etc. Cable or Wire: Cable is an important medium in data communication. Cables are generally used for data transfer over short range networking such as LAN...
Post a Comment
Read more