Timeline for Data retrieving is taking more than 4hrs to fetch 400K records
Current License: CC BY-SA 4.0
23 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 21, 2023 at 4:45 | vote | accept | Python coder | ||
| Aug 2, 2023 at 11:54 | history | edited | Python coder | CC BY-SA 4.0 |
deleted 1 character in body
|
| Aug 2, 2023 at 11:53 | comment | added | Python coder | @JustinCave Yes, you are correct. It contain 15 million rows, it my mistake, I will update the post. | |
| Aug 2, 2023 at 11:51 | comment | added | Justin Cave | Note that your execution plan seems to indicate that the table has 15 million rows, not 1.5 million. Unless you've set statistics on the table to make SQL Server believe that the table is 10x larger than it actually is. | |
| Aug 2, 2023 at 9:43 | answer | added | Caesar Dutta | timeline score: -1 | |
| Aug 2, 2023 at 6:40 | history | edited | Python coder | CC BY-SA 4.0 |
edited body
|
| Aug 2, 2023 at 6:01 | history | edited | Python coder | CC BY-SA 4.0 |
edited body
|
| Aug 2, 2023 at 5:17 | history | edited | Python coder | CC BY-SA 4.0 |
added 233 characters in body
|
| Aug 2, 2023 at 4:44 | history | edited | Python coder | CC BY-SA 4.0 |
added 2 characters in body
|
| Aug 1, 2023 at 19:17 | history | edited | Python coder | CC BY-SA 4.0 |
added 44 characters in body
|
| Aug 1, 2023 at 18:48 | history | edited | Python coder | CC BY-SA 4.0 |
added 2 characters in body
|
| Aug 1, 2023 at 18:31 | history | edited | Python coder | CC BY-SA 4.0 |
added 317 characters in body
|
| Aug 1, 2023 at 18:03 | history | edited | Python coder | CC BY-SA 4.0 |
added 355 characters in body
|
| Aug 1, 2023 at 12:42 | answer | added | J.D. | timeline score: 3 | |
| Aug 1, 2023 at 12:36 | comment | added | J.D. | @TiborKaraszi Note, in his dupe question on StackOverflow, he confirms there's a clustered index too, so no heap here. | |
| Aug 1, 2023 at 11:17 | comment | added | Tibor Karaszi | A heap table can have lots of unused space, based on the modification pattern on that table. That might explain your case. | |
| Aug 1, 2023 at 7:45 | comment | added | Python coder |
@TiborKaraszi The table contains nonclustered index on a different column, which I am not using for my filter. Do you mean heap table is slow or fast?
|
|
| Aug 1, 2023 at 7:37 | comment | added | Tibor Karaszi | Check whether the table is a heap table. I.e. a table with no clustered index. | |
| Aug 1, 2023 at 7:17 | comment | added | Ergest Basha | While our subject matters certainly overlap, this activity splinters answers and can cause unnecessary work for other users. Usually one of the copies of the question will either be deleted, or migrated / closed / merged - What topics can I ask about here? . Please for performance queries see Asking query performance questions | |
| Aug 1, 2023 at 7:08 | comment | added | Python coder | @ErgestBasha Any specific reason? I thought it's more relevant to this site, but trying my luck for solution on both sites. | |
| Aug 1, 2023 at 7:06 | history | edited | Python coder | CC BY-SA 4.0 |
added 114 characters in body
|
| Aug 1, 2023 at 7:05 | comment | added | Ergest Basha | Please do not cross post . Data retrieving is taking more than 4hrs to fetch 400K records | |
| Aug 1, 2023 at 5:39 | history | asked | Python coder | CC BY-SA 4.0 |