121 reputation
15
bio website
location
age
visits member for 3 years, 3 months
seen Nov 26 at 9:50

Oct
31
awarded  Notable Question
Nov
22
awarded  Popular Question
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?