Think of it this way. You tear all of the pages out of a book and throw them on the floor.
Now I say go find (XYZ) content on page 234.
Well now you need to sort through this mess just to find page 234; THEN locate the content.
If the pages were still in the book you could turn to page 234 pretty darn quick.
Further if their were a legend in the beginning of the book that said (XYZ) content was on page 234, second paragraph, third sentence, you would be able to turn right to what I want.
SQL Server.
Select one or more rows (Single row index / Composite index) and create an index on this data.
Now when you run queries you can sort by the data that you need rather than SCANNING the entire table looking for it.
SO in conclusion you want to SEARCH for data against an INDEX (Sort) for performance, scalability, speed.
What is the difference between statistics and parameter
difference between Data Mining and OLAP
What is the difference between the population and sample regression functions? Is this a distinction without difference?
What is the difference between quota sampling and cluster sampling
20.9182% difference.
Searching allows you to find data that meets specific criteria. Sorting allows you to organize that data, based upon the rules you choose (most common is alphabetical).
When you're searching for something you are simply examining each entity, comparing them with another entity in order to locate a match. When you're sorting entities, you are re-arranging the order of those entities. In both cases you will perform a comparison between two entities at a time, the only real difference is that you do not re-arrange the entities when searching.
vikram
Yes, searching and sorting are fifferent things.
good
me too searching!!
Classification is sorting out things due to scientific process. Partition is eminent domain.
looking is like searching, seeing is unexpected.
Searching: the engine searches for your criteria, and shows any result found. Filtering: the engine searches the same way, but excludes things you tell it to ignore.
I think your sad to actually have to ask this.. but maybe I'm sad for searching about it and then awnsering your question...
Surfing is more like just looking around and searching usually has a goal in mind.
Sorting is grouping items by similarities they have in common. eg placing all the green blocks together, the red blocks together and so on. Classifying is placing items in pre-determined groups. eg classifying dogs as mammals, and frogs as amphibians.