Big table, small table

s and indexes are analyzed. Why would taking an index off make this query faster? What doesn't the CBO know that not using an index is the best path? --- Sherrie Kubis Southwest Florida Water Management District 2379 Broad Street Brooksville FL 34604-6899 Phone: (352) 796-7

Poor query performance on smaller tables

table WMT025_SP returns millisecond results with or without parallel. The next two largest, WMT023 and WMT027 work better with parallel than without. I am stumped, and not sure what to look at next. Does anyone have any insights that could point me in the right direction? ---

UNDO Tablespace

incremental commits in their code rather than extending the size of the UNDO tablespace. What extension to the datafile works today, may not work tomorrow because of a larger number of changes. --- Sherrie Kubis Southwest Florida Water Management District 2379 Broad Street Brook

UNDO Tablespace

every user querying our database would have copies of the tables in the UNDO, and I'd need about a gazillion gb to handle that. Does anyone have any insights on how the UNDO physically works? --- Sherrie Kubis Southwest Florida Water Management District 2379 Broad Street Brooksvil

Oracle configuration on SAN

that I've found is marketing, and a description of what SANs are. I'm looking for recommendations for Oracle configuration. Everything I find on OTN sends me to the vendor, but the vendor doesn't have anything specific to Oracle. --- Sherrie Kubis Southwest Florida

Functions

7;m not sure this is a valid reason. Seems that using a DB2 function or TS derived expression in terms of performance will be comparable. Do you have any insights or thoughts to share that may help me in this decision? My appreciation in advance. --- Sherrie Kubis Southwest Florida W

Functions

7;m not sure this is a valid reason. Seems that using a DB2 function or TS derived expression in terms of performance will be comparable. Do you have any insights or thoughts to share that may help me in this decision? My appreciation in advance. --- Sherrie Kubis Southwest Florida W

Operating system choice

d thing, but I also worry about the stability and availability of my database that I would be presenting to my customers. If anyone has any insights, statistics, facts or links to documentation presenting such, I'd sure appreciate the help. --- Sherrie Kubis Southwest Florida Water

Base table of materialized views

ature that I have come to depend on. Does anyone know of a workaround for this problem? Any insights would be appreciated. ------- Sherrie Kubis Southwest Florida Water Management District 2379 Broad Street Brooksville FL 34604-6899 Phone: (352) 796-7211, Ext. 4033 Fax: (352) 754-

Analyze schema1.mytable from schema2 in a stored procedure

re interpreted differently within stored procedures that from SQLPLUS? Any insights would be appreciated. ++ Sherrie Kubis Southwest Florida Water Management District 2379 Broad Street Brooksville FL 34604-6899 Phone: (352) 796-7211, Ext. 4033 Fax: (352) 754-6776 Email: Mailto:[EMAIL PROTECTED] --

Copy files from within Oracle

d are forced to use VB because of our third-party software. How would you go about doing this? Any insights would be appreciated. _______ Sherrie Kubis Southwest Florida Water Management District 2379 Broad Street Brooksville FL 34604-6899 Mailto:[EMAIL PROTECTED] --

Re: FK Constraints

I would never, ever, ever, ever agree to a database without referential integrity imposed by the RDBMS that was in my control. I thank you for the opportunity to vent (-_-) _______ Sherrie Kubis Southwest Florida Water Management District 2379 Broad Street Brooksvill

Opinions on OLTP

g the database to do its job? It seems silly to me to put all of your checks into code because changes and maintenance would just kill you, not to mention consistency, or lack thereof. Any insights into this would be appreciated. Sherrie Kubis Southwest Florida Water Management District 2379