473,324 Members | 2,501 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

select query is taking some time to return values

Hi,
I have a problem, i have used one condition in where clause .....
but it is taking some time to return values.......
so my procedure is taking lot of time.......
for the same table if i query with another column in where clause within fraction of second i getting values.......

This query is taking some time......
Expand|Select|Wrap|Line Numbers
  1.  
  2. SELECT entrykey,uniquekey FROM frt_app.ENTRIES_WES WHERE uniquekey=9422077251
  3.  
  4. --This is fast [i have createdit as primary key]
  5.  
  6. SELECT entrykey,uniquekey FROM frt_app.ENTRIES_WES WHERE entrykey=983654
  7.  
  8.  


i also tried by creating index..........but i am not able to solve
Please kindly help me .....This is very urgent.......
Mar 18 '08 #1
2 2088
amitpatel66
2,367 Expert 2GB
Hi,
I have a problem, i have used one condition in where clause .....
but it is taking some time to return values.......
so my procedure is taking lot of time.......
for the same table if i query with another column in where clause within fraction of second i getting values.......

This query is taking some time......
Expand|Select|Wrap|Line Numbers
  1.  
  2. SELECT entrykey,uniquekey FROM frt_app.ENTRIES_WES WHERE uniquekey=9422077251
  3.  
  4. --This is fast [i have createdit as primary key]
  5.  
  6. SELECT entrykey,uniquekey FROM frt_app.ENTRIES_WES WHERE entrykey=983654
  7.  
  8.  


i also tried by creating index..........but i am not able to solve
Please kindly help me .....This is very urgent.......
Yes, the way to get the correct data from the table is using a primary key column in WHERE clause. So why dont you use Primary key column it self?
Mar 18 '08 #2
Saii
145 Expert 100+
Can you run an explain plan on the query. Also can mention details about the size of table, column specs and what index you created and whether that was referenced during execution.
Mar 20 '08 #3

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

Similar topics

4
by: psql-mail | last post by:
I am running a SELECT to get all tuples within a given date range. This query is much slwoer than i expected - am i missing something? I have a table 'meta' with a column 'in_date' of type...
1
by: Andrew McNab | last post by:
Hi folks, I have a problem with an MS Access SQL query which is being used in an Access Report, and am wondering if anyone can help. Basically, my query (shown below) gets some records from a...
19
by: William Wisnieski | last post by:
Hello Everyone, I have a main form with a datasheet subform that I use to query by form. After the user selects two criteria on the main form and clicks the cmdShowResults button on the main...
6
by: Martin Lacoste | last post by:
Ok, before I headbutt the computer... don't know why when I add criteria in a query, I get an 'invalid procedure call'. I also don't know why after searching the help in access, the various access...
6
by: jjturon | last post by:
Can anyone help me?? I am trying to pass a Select Query variable to a table using Dlookup and return the value to same select query but to another field. Ex. SalesManID ...
1
by: suslikovich | last post by:
Hi all, I am getting this error when insert values from one table to another in the first table the values are varchar (10). In the second they are datetime. The format of the data is mm/dd/yyyy...
22
by: MP | last post by:
vb6,ado,mdb,win2k i pass the sql string to the .Execute method on the open connection to Table_Name(const) db table fwiw (the connection opened via class wrapper:) msConnString = "Data Source="...
21
by: Leena P | last post by:
i want to basically take some information for the product and let the user enter the the material required to make this product 1.first page test.php which takes product code and displays...
3
by: bob laughland | last post by:
Hi All, I have another SQL question, and this one is going to be difficult to explain. I have a table like this rowid name changed 1 a 1 1 ...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.