Databases
AdventureWorks2019
ProductReviewProduction
 
Search
scanning

Scanning is the default search option for small tables.

Enter text here to perform a scan over supported column types.

Text columns with limited length use a substring search If the entered text is a number, integer columns will be scanned for an exact match of the value.

text to scan for
› search options
seeking

Seeking is the default search option for large tables.

Seeking requires indexes and can only be done using the column (or columns) the index is defined on.

In the single-column case, the database will seek to the position the entered search term would be at and return all rows greater or equal to that value.

In the multiple-column case, the above still applies to the column you supplied non-empty search text for. All previous columns, however, will be using an equality match.

ProductReviewID
ProductIDReviewerName
 
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PRJohn Smith
    primarykey
    data
    text
    singulars
    1. PTMountain Bike Socks, M
      singulars
      1. PMMountain Bike Socks
      1. PSSocks
  2. PRDavid
    primarykey
    data
    text
    singulars
    1. PTHL Mountain Pedal
      singulars
      1. PMHL Mountain Pedal
      1. PSPedals
  3. PRJill
    primarykey
    data
    text
    singulars
    1. PTHL Mountain Pedal
      singulars
      1. PMHL Mountain Pedal
      1. PSPedals
  4. PRLaura Norman
    primarykey
    data
    text
    The Road-550-W from Adventure Works Cycles is everything it's advertised to be. Finally, a quality bike that is actually built for a woman and provides control and comfort in one neat package. The top tube is shorter, the suspension is weight-tuned and there's a much shorter reach to the brake levers. All this adds up to a great mountain bike that is sure to accommodate any woman's anatomy. In addition to getting the size right, the saddle is incredibly comfortable. Attention to detail is apparent in every aspect from the frame finish to the careful design of each component. Each component is a solid performer without any fluff. The designers clearly did their homework and thought about size, weight, and funtionality throughout. And at less than 19 pounds, the bike is manageable for even the most petite cyclist. We had 5 riders take the bike out for a spin and really put it to the test. The results were consistent and very positive. Our testers loved the manuverability and control they had with the redesigned frame on the 550-W. A definite improvement over the 2002 design. Four out of five testers listed quick handling and responsivness were the key elements they noticed. Technical climbing and on the flats, the bike just cruises through the rough. Tight corners and obstacles were handled effortlessly. The fifth tester was more impressed with the smooth ride. The heavy-duty shocks absorbed even the worst bumps and provided a soft ride on all but the nastiest trails and biggest drops. The shifting was rated superb and typical of what we've come to expect from Adventure Works Cycles. On descents, the bike handled flawlessly and tracked very well. The bike is well balanced front-to-rear and frame flex was minimal. In particular, the testers noted that the brake system had a unique combination of power and modulation. While some brake setups can be overly touchy, these brakes had a good amount of power, but also a good feel that allows you to apply as little or as much braking power as is needed. Second is their short break-in period. We found that they tend to break-in well before the end of the first ride; while others take two to three rides (or more) to come to full power. On the negative side, the pedals were not quite up to our tester's standards. Just for fun, we experimented with routine maintenance tasks. Overall we found most operations to be straight forward and easy to complete. The only exception was replacing the front wheel. The maintenance manual that comes with the bike say to install the front wheel with the axle quick release or bolt, then compress the fork a few times before fastening and tightening the two quick-release mechanisms on the bottom of the dropouts. This is to seat the axle in the dropouts, and if you do not do this, the axle will become seated after you tightened the two bottom quick releases, which will then become loose. It's better to test the tightness carefully or you may notice that the two bottom quick releases have come loose enough to fall completely open. And that's something you don't want to experience while out on the road! The Road-550-W frame is available in a variety of sizes and colors and has the same durable, high-quality aluminum that AWC is known for. At a MSRP of just under $1125.00, it's comparable in price to its closest competitors and we think that after a test drive you'l find the quality and performance above and beyond . You'll have a grin on your face and be itching to get out on the road for more. While designed for serious road racing, the Road-550-W would be an excellent choice for just about any terrain and any level of experience. It's a huge step in the right direction for female cyclists and well worth your consideration and hard-earned money.
    singulars
    1. PTRoad-550-W Yellow, 40
      singulars
      1. PMRoad-550-W
      1. PSRoad Bikes
 

Querying!

 
Guidance
A table list

Lists show table rows with slightly less information than detail views, therefore not requiring section labels.

This list shows the beginning of an entire table.

Search

Searching on lists works via indexes when the table is large. On the left you see input fields generated from viable indexes and an expandable report for all indexes that are unavailable for searching with the respective reasons.

Searching along indexes is called seeking and this is one of the main values that databases offer. The trivial alternative is scanning, which is potentially inefficient as it works by walking the entirety of the candidate rows to find the matches.

The offer to scan is given for small tables. Currently, this only works on text and integer columns and they are searched all at once.

Loading more

Loading more rows than the initial 10 results is also currently restricted to a single reloading of 100 entries.

A future version will keep auto-loading on scroll for tables that have suitable indexes.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload