meta user
network profile
| bio | website | ddbcinc.com |
|---|---|---|
| location | Rochester Hills, MI | |
| age | 36 | |
| visits | member for | 2 years, 5 months |
| seen | 10 hours ago | |
| stats | profile views | 380 |
Oracle ACE
|
Apr 6 |
comment |
How to choose the last recorded added without sorting A table can have multiple indexes (it can only have one clustered index). The simplest approach would be to create a non-clustered index on (UserID, DTime desc)-- if there is only an index on the primary key now, creating this new index should dramatically increase performance. UserID doesn't need to be unique to be part of an index (nor does the combination of UserID and DTime need to be unique), you just need to ensure that the index is non-unique if that is the case. |
|
Apr 6 |
comment |
How to choose the last recorded added without sorting Wouldn't you want the leading column of the composite index to be UserID since that's what the equality predicate is on? |
|
Apr 6 |
answered | How to choose the last recorded added without sorting |
|
Mar 24 |
comment |
Materialized views in oracle @lewap - Added a link to some documentation |
|
Mar 24 |
revised |
Materialized views in oracle added 256 characters in body |
|
Mar 24 |
comment |
Oracle materialized view refresh schedule @lewap - Just posted a reply over there. |
|
Mar 24 |
answered | Materialized views in oracle |
|
Mar 24 |
answered | Oracle materialized view refresh schedule |
|
Mar 21 |
answered | How to create a user with a particular user_id? |
|
Mar 10 |
comment |
Introduce partitions into an existing non-partitioned table I suspect Oracle doesn't provide a simpler syntax because people with large, unpartitioned existing tables will frequently want to have very fine-grained control about how they move their data to a partitioned table. Doing an exchange partition and then splitting the partitions can be syntactically straightforward but generate substantial performance problems. Creating a new table with the appropriate partitions and moving the data over can be parallelized and is relatively simple but it generally requires downtime. Using DBMS_REDEFINITION can be done online but may require monitoring. |
|
Mar 9 |
answered | Sub queries or joins? |
|
Mar 5 |
answered | database duplication VS database replication |
|
Mar 2 |
comment |
SGA_MAX_SIZE and SGA_TARGET Specifying the Oracle version would also be helpful. If you're on 11g, for example, you may be better served setting MEMORY_TARGET rather than the separate SGA_TARGET and PGA_TARGET. |
|
Mar 2 |
revised |
SGA_MAX_SIZE and SGA_TARGET edited tags |
|
Mar 2 |
answered | SGA_MAX_SIZE and SGA_TARGET |
|
Feb 28 |
answered | What database front end do you use? |
|
Feb 28 |
answered | Getting the “ORA-00911” error when I am trying to insert more than 1 row |
|
Feb 28 |
answered | How can I unload Oracle database tables into a csv files? |
|
Feb 25 |
comment |
Is where x = 0 or x is null to be replaced by where isnull(x, 0) = 0 resp. where NVL(x, 0) = 0 What is "resp" an abbreviation for? I can't quite figure out what word you're intending to use there. |
|
Feb 25 |
answered | Is where x = 0 or x is null to be replaced by where isnull(x, 0) = 0 resp. where NVL(x, 0) = 0 |
