answersLogoWhite

0

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.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

What is the difference between sorting and searching in a database?

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).


What is the difference between searching and sorting in design analysis algorithm?

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.


What do you mean by Sorting and Searching?

vikram


Is binary sorting different from binary search?

Yes, searching and sorting are fifferent things.


What is the difference between worst case and best case scenario of sorting techniques?

good


What is the difference between specific conductivity and cation conductivity?

me too searching!!


The difference between partition to classification?

Classification is sorting out things due to scientific process. Partition is eminent domain.


What is the difference between the word look and see?

looking is like searching, seeing is unexpected.


What is the difference between searching and filtering?

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.


What is the difference between a pen and a marker?

I think your sad to actually have to ask this.. but maybe I'm sad for searching about it and then awnsering your question...


What is the difference between surfing and browsing the internet?

Surfing is more like just looking around and searching usually has a goal in mind.


What is the difference between sorting and classifying?

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.