Full table scan: Revision history

Filter revisionsshowhide

To date:

Tag filter:

Invert selection

External tools:

For any version listed below, click on its date to view it. For more help, see Help:Page history and Help:Edit summary. (cur) = difference from current version, (prev) = difference from preceding version, m = minor edit, → = section edit, ← = automatic edit summary

curprev 20:3520:35, 24 April 2024‎ Archyx1 talk contribs‎ m 5,733 bytes +4‎ →‎Examples undo
curprev 20:3420:34, 24 April 2024‎ Archyx1 talk contribs‎ m 5,729 bytes +4‎ →‎Examples undo
curprev 20:3220:32, 24 April 2024‎ Archyx1 talk contribs‎ 5,725 bytes +52‎ Adding short description: "Sequential scan of a database" undo Tag: Shortdesc helper

curprev 10:0010:00, 12 February 2024‎ Frap talk contribs‎ 5,673 bytes +105‎ No edit summary undo

curprev 23:2723:27, 24 December 2023‎ RJFJR talk contribs‎ 5,568 bytes +21‎ move ext link to ext links section undo
curprev 23:2623:26, 24 December 2023‎ RJFJR talk contribs‎ 5,547 bytes −1‎ →‎When the Optimizer Considers a Full Table Scan{{Cite web|url=https://docs.oracle.com/database/121/TGSQL/tgsql_optop.htm|title=Optimizer Access Paths|last=|first=|date=2013|website=|publisher=Oracle|access-date=}}: move ref out of heading undo

curprev 17:4717:47, 18 November 2023‎ Wes.turner talk contribs‎ 5,548 bytes +42‎ →‎See also: See also > Query plan, Query optimization undo Tags: Mobile edit Mobile web edit
curprev 17:4417:44, 18 November 2023‎ Wes.turner talk contribs‎ 5,506 bytes +21‎ →‎See also: See also > Database index undo Tags: Mobile edit Mobile web edit

curprev 07:0907:09, 8 May 2022‎ 50.93.222.103 talk‎ 5,485 bytes 0‎ →‎Examples undo

curprev 18:0118:01, 25 November 2020‎ Arjayay talk contribs‎ m 5,485 bytes −4‎ Duplicate word removed undo
curprev 14:5714:57, 25 November 2020‎ 38.64.74.22 talk‎ 5,489 bytes +1,246‎ The existing examples did not clearly explain why they would result in a table scan and also contained errors - e.g. the sql in example 1 referenced columns named category_id1 and category_id2 while the explanatory text referenced a column named id. Additionally, using abstract examples with nearly identical columns like "category_id1" and "category_id2" are less easily understood than more real-world names like "name" and "color". undo

curprev 00:4100:41, 30 August 2020‎ I dream of horses talk contribs‎ m 4,243 bytes −21‎ AWB cleanup patrol, removed stub tag undo Tag: AWB

curprev 16:0416:04, 15 October 2019‎ Iafisher talk contribs‎ m 4,264 bytes −7‎ Capitalization undo

curprev 23:2523:25, 18 March 2019‎ Newslinger talk contribs‎ 4,271 bytes +36‎ Added {{cleanup rewrite}} tag to article (TW) undo
curprev 23:2423:24, 18 March 2019‎ 64.125.238.131 talk‎ 4,235 bytes −698‎ →‎How to Avoid Full table scan: This is not an article about MySQL undo Tag: section blanking

curprev 23:4423:44, 31 January 2019‎ Kyudan2 talk contribs‎ m 4,933 bytes −38‎ Improve readability by correcting grammar undo

curprev 14:1914:19, 15 July 2018‎ 195.176.112.156 talk‎ 4,971 bytes +2‎ →‎Pros and Cons undo

curprev 06:3306:33, 26 August 2017‎ Jon Kolbert talk contribs‎ m 4,969 bytes +1‎ Updating links from HTTP→HTTPS for Microsoft TechNet undo

curprev 20:2720:27, 5 March 2017‎ 50.37.245.137 talk‎ 4,968 bytes +4‎ minor grammatical change undo
curprev 20:2520:25, 5 March 2017‎ 50.37.245.137 talk‎ 4,964 bytes +5‎ added words "in a", sounds better. undo
curprev 20:2420:24, 5 March 2017‎ 50.37.245.137 talk‎ 4,959 bytes +4‎ added word "the", makes it sound better. undo

curprev 23:3423:34, 26 January 2017‎ 8.28.180.9 talk‎ 4,955 bytes +9‎ removes the evil select *. is not part of the example, and teaches poor habits undo

curprev 10:1310:13, 7 December 2016‎ 125.16.3.251 talk‎ 4,946 bytes 0‎ No edit summary undo
curprev 10:1210:12, 7 December 2016‎ 125.16.3.251 talk‎ 4,946 bytes 0‎ No edit summary undo

curprev 19:5819:58, 8 November 2016‎ Chrylis talk contribs‎ 4,946 bytes +2‎ →‎Overview: copy edit undo
curprev 19:5719:57, 8 November 2016‎ Chrylis talk contribs‎ 4,944 bytes −178‎ →‎Overview: copy edit undo

curprev 01:2101:21, 7 October 2016‎ Edgy4 talk contribs‎ 5,122 bytes −1‎ →‎Overview undo

curprev 22:2822:28, 23 September 2016‎ D673650096 talk contribs‎ 5,123 bytes +3‎ No edit summary undo Tag: Visual edit
curprev 21:4021:40, 23 September 2016‎ Kate8528577 talk contribs‎ 5,120 bytes +32‎ No edit summary undo
curprev 21:4021:40, 23 September 2016‎ Kate8528577 talk contribs‎ 5,088 bytes +17‎ →‎Overview undo Tag: Visual edit

curprev 21:2321:23, 16 September 2016‎ D673650096 talk contribs‎ 5,071 bytes −295‎ No edit summary undo Tag: Visual edit

curprev 02:1302:13, 15 September 2016‎ 152.7.224.5 talk‎ 5,366 bytes −3‎ No edit summary undo

curprev 20:1220:12, 13 September 2016‎ D673650096 talk contribs‎ 4,760 bytes +1,038‎ How to avoid full table scan, See also, References undo Tag: Visual edit
curprev 19:4119:41, 13 September 2016‎ D673650096 talk contribs‎ 3,722 bytes +621‎ When the optimizer considers a full table scan undo Tag: Visual edit
curprev 19:3719:37, 13 September 2016‎ D673650096 talk contribs‎ 3,101 bytes +1,882‎ Overview undo

curprev 13:1613:16, 24 June 2014‎ 62.25.109.198 talk‎ 1,219 bytes −1‎ Removed redundant comma. undo

curprev 09:0909:09, 22 November 2013‎ Jost Riedel talk contribs‎ 1,220 bytes −11‎ There are no writes when scanning a file undo

curprev 10:3110:31, 7 November 2013‎ Yobot talk contribs‎ m 1,231 bytes +1‎ WP:CHECKWIKI error fixes using AWB (9585) undo

curprev 17:5417:54, 3 October 2013‎ Hirsutism talk contribs‎ 1,230 bytes +357‎ add basic references undo

curprev 19:0819:08, 26 December 2010‎ Gene93k talk contribs‎ 873 bytes +164‎ stub wikify - format edits; added internal links, category & stub template; tagged {{unreferenced}} undo

curprev 04:5204:52, 21 December 2010‎ Vaibhavkaushal123 talk contribs‎ 709 bytes +709‎ ←Created page with 'Full Table Scan (also known as Sequential Scan) is a scan made on the database where each row of the table under scan is read in a sequential (serial) order and the...'

24 April 2024

12 February 2024

24 December 2023

18 November 2023

8 May 2022

25 November 2020

30 August 2020

15 October 2019

18 March 2019

31 January 2019

15 July 2018

26 August 2017

5 March 2017

26 January 2017

7 December 2016

8 November 2016

7 October 2016

23 September 2016

16 September 2016

15 September 2016

14 September 2016

13 September 2016

24 June 2014

22 November 2013

7 November 2013

3 October 2013

26 December 2010

21 December 2010