network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 8 months |
| seen | Apr 2 at 11:27 | |
| stats | profile views | 7 |
|
Feb 7 |
asked | Oracle: Mirror database changes between two databases |
|
Dec 4 |
awarded | Editor |
|
Dec 4 |
revised |
Oracle 11g: “With Clause” very slow added 174 characters in body |
|
Dec 4 |
comment |
Oracle 11g: “With Clause” very slow @Phil Yes, it always runs slow. I suspect that it is materializing every time. Do you know if I can get rid of this behaviour? |
|
Dec 4 |
awarded | Student |
|
Dec 4 |
asked | Oracle 11g: “With Clause” very slow |
|
Sep 25 |
awarded | Teacher |
|
Sep 22 |
awarded | Supporter |
|
Sep 22 |
comment |
What is an Effective Way to Count the Number of Pages in Oracle? If the count is expensive already have you ever tried to retrieve the last pages? The paging alone will probably be extremely slow when you've got many rows. Do you really need to page that many results? Also be aware that you need to provide a unique order (PK will be fine) or else Oracle will treat some pages to be the same, that is, you will see the same results on page 56, 57 and 58 if you're unlucky. If you need to support that large datavolumes, try to optimize it in a way that keeps the records in a cache or in memory if possible. |
|
Sep 22 |
comment |
Should you ever not assign an unique ID to each row in a table? @Jeff O: Honestly, we don't know what he is asking about yet. |
|
Sep 22 |
comment |
Should you ever not assign an unique ID to each row in a table? Do you mean a unique key/constraint like a PK or do you mean a single identity column by unique ID? |
|
Sep 22 |
answered | Should you ever not assign an unique ID to each row in a table? |
