execution plan is same even though it takes 10 times longer to run
I have a query that accesses a table with a non-clustered index. When I drop the index and run the query, it takes 1.25 minutes to run. With the index, it takes 2 seconds to run. Yet, the execution plan is the same with or without the index. How can that be?Thank you!
View Answer
| Mar 3 2008 5:07 AM GMT
| asked by
Abbi
Execution Plan, Indexes, Performance/Tuning
Performance Tracking of Stored Procedures
we have a current system where a COBOL stored procedure is called by a .NET application. This COBOL SP then calls multiple COBOL subprograms which perform calculations and update files and then eventually return a value to the .NET app. We have a limitation in tracking the performance of each...
View Answer
| Feb 26 2008 7:07 PM GMT
| asked by
Pcrum73
COBOL, COBOL stored procedure, Performance/Tuning
Database Admin…
Will the real DBA please standup!Is there a forum just for DBAs? I got started in 1995 when a recruiter asked me if I wanted to be a DBA on an AS/400? Was I surprised! However, the shop that hired me did not understand what a DBA on AS/400 really did... nor did I. Well, I ended up doing...
View Answer
| Oct 10 2007 3:37 PM GMT
| asked by
Znason
DBA, Security, Relation Database
media recovery
Hi,Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide...
View Answer
| Apr 7 2007 5:04 AM GMT
| asked by
sukaina
Oracle, Database, DB2
moving datafiles to different locations
Hi,Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me.Regards.
View Answer
| Mar 25 2007 12:18 AM GMT
| asked by
sukaina
Backup & recovery, Performance/Tuning
Exchange 2000 server and ms outlook 2000 installation,configuration
Hi,I am going to deply MS Exchange 2000 server in my organisation, Before that we have no message system, Now we have 200 systems of windows XP/Windows 98 with MS Windows 2000 Advanced Server. Pls guide me how to Install and Configure MS Echange 2000 Server and MS Outlook 2000.What r the parameters...
View Answer
| Jan 8 2007 11:09 PM GMT
| asked by
chinmoymohanty
Exchange security, Hardware, Cabling
ORA-12535
My database runs on 9i.There are remote databases that connected to it.Today all of them are failing to connect because of the error message ora-12535.I increased the CONNECT_TIMEOUT but error still persists.I even set it to zero (0) and the system hangs indefinately.tnsping to these remote...
View Answer
| Oct 26 2006 5:44 AM GMT
| asked by
SINETA
Windows, Architecture/Design, Availability
Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g
Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B.The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server...
View Answer
| Oct 24 2006 11:28 AM GMT
| asked by
108108
Database, Oracle, DB2
error in connection between oracle8i&developer2000
I'm installing Oracle8i on Windows 2000 professional on NTFS partition and on the same machine I'm installing Developer 2000 or form6 in a different partition. When I try to connect Developer to Oracle, I get the error "TNS could not resolve." Please provide a solution. Can I use Oracle8i...
View Answer
| Sep 18 2006 4:46 AM GMT
| asked by
POWERINIT
Database, Oracle, DB2
Oracle Application or Database on its own server.
Which would increase performance more. Moving an Oracle demand planning and forcasting application or an Oracle database onto its own server and or a faster server? There is some debate among myself and a couple of coworkers. I feel that the workhorse of Oracle is the database and that it should be...
View Answer
| Jul 12 2006 10:47 AM GMT
| asked by
ktharrell
Oracle, Database, DB2
Running a script at specified runtime
I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime?Thanks
View Answer
| Jul 10 2006 12:23 AM GMT
| asked by
Columbus
Oracle, Windows, Oracle administration
PL/SQL performance tuning…
I need to move data between to schemas. I have a created packaged code to accomplish this. The problem is the execution time. When running the insert statements from the source schema to insert data into the target schema, it takes considerably longer to complete the statement than if I copied...
View Answer
| Apr 12 2006 1:48 PM GMT
| asked by
jelewis
SQL, Performance/Tuning, Oracle 10g
inserts through a database link
Hello every body. Here I go again...Do you know if there is a restriction about performing inserts through a database link ?We are experiencing the following situation:We have two Oracle 8i instances running on a win 2k3 server, and a Forms applications needs to insert data from one instance to...
View Answer
| Mar 31 2006 10:13 AM GMT
| asked by
carlosdl
Database, Oracle, DB2
Using optimizer hints in Forms
Hello everybody.A few weeks ago I posted a question about Sql Tuning in Oracle, and I have been experimenting with optimizer hints and execution plans (all this in Sql Plus), but now, a doubt arises to me.Can I use the optimizer hints in Forms 6i (program units or triggers) ?Since they look like a...
View Answer
| Mar 13 2006 12:28 AM GMT
| asked by
carlosdl
Oracle, Oracle administration, Performance/Tuning
STRSST User ID Disabled.
How do you re-enable the user id for STRSST when it has been disabled?
View Answer
| Aug 1 2005 8:42 AM GMT
| asked by
bkr0963c
OS/400, iSeries, i5
SQL Server worst practices
Hello,My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. Jeremy Kadlec, a performance and tuning expert at SearchSQLServer.com, recently wrote up what he considers some of the worst SQL Server practices and offered recommended fixes. You can see the list here:...
View Answer
| Jul 25 2005 12:16 AM GMT
| asked by
nbellistri
Hardware, Database Management Systems, SQL Server
Information required on 10Gigabit Ethernet cards
Hello All,I needed some information and datapoints on the following topics:- today what is 10GbE card used for?- what do you see the future for 10GbE?- what do you think is an acceptable price point for this card (just a guesstimate)? Today it is very expensive as compared to the regular 1GbE...
View Answer
| Jul 22 2005 12:50 AM GMT
| asked by
rigveda
DataCenter, Data center design, Data center operations
STRDSKRGZ, TRCASPBAL, and STRASPBAL commands.
Are any of you familiar with using these commands, the amount of time it takes to perform these commands, the requirements (restricted system or not, etc.), or where I can obtain some documentation on these commands so I can read up on them? I appreciate the info and help.
View Answer
| Jul 19 2005 9:17 AM GMT
| asked by
bkr0963c
OS/400, iSeries, i5
Upgrade to SQL Server 2005 sooner or later?
Hello,I'm the editor of SearchSQLServer.com and I am hoping to get your opinons on a timely topic.Prior to Microsoft announcing its November 7 release date for SQL Server 2005, we had run a poll asking site members: How have the delays with SQL Server 2005 affected your organization's plans?58%...
View Answer
| Jul 15 2005 10:19 AM GMT
| asked by
RobynLorusso23
Database Management Systems, SQL Server, Administration
File transfer to the iSeries problem.
I am trying to transfer an excel speadsheet file to my AS/400. I have tried setting up a file transfer through client access and tried sending the file directly from Excel. Both times I get the following errorcwbtf0023 - pc file description file was not specified or is emptyThe file is not empty....
View Answer
| Jul 13 2005 10:11 AM GMT
| asked by
bkr0963c
AS/400, OS/400, iSeries
