472,378 Members | 1,150 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,378 software developers and data experts.

Query too long

Hello everyone,

I'm having some troubles displying this query in SQL Developer.I have 3 tables:
MASTER_TRANSACTION_HIST is a big table with millions of rows
LOCAL and PLAFOND are small cardinality tables.

select mt.LOCAL_ID, plf.SUBAGENT_ID, l.DESCRIPTION, to_char(min(mt.DATE_TRANS), 'dd-mm-yyyy')


where mt.LOCAL_ID = l.LOCAL_ID


and mt.PLAFOND_ID = plf.PLF_ID

and mt.DATE_TRANS >= to_date('01-01-2007','dd-mm-yyyy') and mt.DATE_TRANS < to_date('04-06-2008','dd-mm-yyyy')

and plf.SUBAGENT_ID like '____3__' OR plf.SUBAGENT_ID like '____4__'


This query is taking too much time and giving me an IO error of no space left on device. I presume its too much data for him. Am i doing anything wrong ?

thank you
Jun 4 '08 #1
3 1745
13,262 8TB
What's the exact error message that you get?
You probably just need to create an additional datafile for one of the tablespaces.
Jun 4 '08 #2
What's the exact error message that you get?
You probably just need to create an additional datafile for one of the tablespaces.
Exactly. Problem is solved... thanks a lot.
Jun 4 '08 #3
13,262 8TB
Exactly. Problem is solved... thanks a lot.
Welcome. I find that the error message is usually a complete give away.
A more permanent solution to your problem is to define the dbf file such that it automatically extends when full and not limit it's size. Then you only get that error when the hard drive/partition itself is full.

Or better yet, switch to ASM.
Jun 4 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Harvey | last post by:
Hi, I try to write an asp query form that lets client search any text-string and display all pages in my web server that contain the text. I have IIS 6.0 on a server 2003. The MSDN site says...
by: Bob Bedford | last post by:
We have no access to a mysql NG on my provider's server, so we ask here: We have a long query (long in text) with a UNION between 2 select. We have been informed that some times the query...
by: d.p. | last post by:
Hi all, I'm using MS Access 2003. Bare with me on this description....here's the situation: Imagine insurance, and working out premiums for different insured properties. The rates for calculating...
by: Kory | last post by:
How do you stop a long running query with a SQLConnection or SQLCommand? Calling Close on either just waits until the query is done. Is there a way to stop it? The following on a long query ...
by: MLH | last post by:
I invoked the combo-box wizard today, telling it to use a 4-table union query as a row-source for the combo-box it was assisting me in building. The error I got was without number and stated,...
by: sghi | last post by:
Hi All, I'm new to this group and quite new to access/vba. So, shortly after beginning to write a simple application for my wife, I came across a blocking problem: I need to intercept the sql...
by: Aaron West | last post by:
Try this script to see what queries are taking over a second. To get some real output, you need a long-running query. Here's one (estimated to take over an hour): PRINT GETDATE() select...
by: annecarterfredi | last post by:
I was getting snapshot since the database was responding very slow...here is the query that was in a snapshot: WITH TYPEINTS ( TYPEINT, COLTYPE ) AS ( VALUES ( SMALLINT(1 ), CHAR( 'INTEGER', ...
by: henryrhenryr | last post by:
Perhaps this should be in the PHP forum but I'll try here first... I'm trying to search some fields for complete words. The word can be in the middle of a string of text. My solution (perhaps...
by: Sinner | last post by:
Hi, I have a field name 'USER' in tableMAIN. How do I replace the user names with corresponding user names. I can do that in xl using vlookup but now I'm trying to find a way to do that in...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...
by: ezappsrUS | last post by:
Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
by: jack2019x | last post by:
hello, Is there code or static lib for hook swapchain present? I wanna hook dxgi swapchain present for dx11 and dx9.
by: F22F35 | last post by:
I am a newbie to Access (most programming for that matter). I need help in creating an Access database that keeps the history of each user in a database. For example, a user might have lesson 1 sent...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.