1 Answer - Sort by: Date | Rating
A query is a question that a user will put to the database. Once the query has been raised, it will run through the various objects in which the data has been stored. Usually data will be stored in tables. Software programmers are constantly thinking of ways which will make answering a query that much more faster without compromising on the accuracy of the information.
The solution to this is joining tables that contain different types of information. A query can be directed to only those tables that contain the relevant information. Usually one query will contain multiple criteria, e.g. a product produced in Asia, priced above U.S. $ 30 and that has had sales of U.S. $ 10 million so far. When databases originated, a query would go through all the tables before coming to the right answer. This has changed over the years. Programmers hope to move to a situation where only one table will be queried, so that results are lightening fast.
The solution to this is joining tables that contain different types of information. A query can be directed to only those tables that contain the relevant information. Usually one query will contain multiple criteria, e.g. a product produced in Asia, priced above U.S. $ 30 and that has had sales of U.S. $ 10 million so far. When databases originated, a query would go through all the tables before coming to the right answer. This has changed over the years. Programmers hope to move to a situation where only one table will be queried, so that results are lightening fast.
0
0
- Do Animal Cells Have A Large Vacuole?
- How To Go About Choosing Choices?
- Silver Nitrate And Sodium Chloride Solutions Are Mixed How Many Moles Of Silver Nitrate Are Needed To React With 0.327 Mole Of Sodium Chloride?
- What Are The Contribution Of Foreign Scientist?
- What Makes An Electromagnet Work?
- What Happens When Iron Filings React With Sulphate Powder?
- How Can We Keep Nature?
- How Do Gestures Serve As One Of The Most Effective Method Of Communication?
- How Do The Bedouins Get Water?
- What Is The Difference Between Online Transaction Processing And Online Analytical Pocessing?
- How Can You Stop A Fire In A Frying Pan Safely?
- When We Take Out Our Waste Why Blood Is Also Included?
- Where Do You Get Pass Seeds?
- What Is Solution To Increase The Value Of National Currency?
- Why Is Cooking A Chemical Reaction?
- What Is Grow Food?
- How Many Stone =110kilos?
- What Is Current Economic Problems Which Is Facing Pakistan?
- What Is Ionisation Energy?
- Which Country Do You Like Most?
- What Are Alluvial Terraces?please Give A Detailed Answer.
- How Usage Of Briquettes To Save The World From Pollution?
- What Is The Properties Of Cobalt?
- How To Study The Electrical Properties Of Matter?
- What Is The Differences Between Ethical Lapse And Ethical Dilemma?
New Comment - Comments are editable for 5 min.