[SQL] How to speed up the database query?

Hi everyone! I'm looking for solution to speed up the database query, means that to get resultset as quicker as we can. For example if I've 700 records in the table it will take longer time compared if I've only 20 records. How do we speed up the query?. Any query technique that can be applied

[SQL] Query Problem

If I've 2 tables like this: Country table : with 2 fields (country and id) Country id EnglandE France F JapanJ FlightTo table : with 2 fields(Flight ID and Destination) FlightIDDestination B1 E,J B2

[SQL] Query from different Database

I'm looking for a solution to make a query from two different databases. If anybody has an experience or know how to solve it, please help me. Thanks. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.

[SQL] Display format for column

Hi there! How do we format column size for displaying data in postgresql. for example my data type for customername is varchar(100) and I want to display the first 25 chars. How should I do that? can I do something like: psql > column customername format a25 ---(end of

[SQL] How to get Rows Count

a b dc 01 02 b* 01 02 a* 02 03 02 04 b* 02 04 a* 03 05 04 06 If I've a table like above, how do I make a query to get rows count that doesnt have '*' in it. Can we have other queries than thi

[SQL] Need Help : Query problem

Hi Everybody! If I've a table like below kk | kj | pngk | vote ++--+-- 01 | 01 | a| 10 01 | 01 | b| 10 01 | 01 | c| 10 01 | 02 | a| 10 01 | 02 | b| 10 01 | 03 | a| 10 How do I write a query so that I can get a result as below [ select only a reco

[SQL] Need Help

Hi! If I've a table like this kk kj pngk vote 01 02 a 12 01 02 b 10 01 03 c 5 and I want to have a query so that it give me a result as below. The condition is for each record with the same kk and kj but di

[SQL] Query Problem

Hi there! If I've a table like below. kk kj pngk vote 01 02 c 10 01 02 b 5 How do I make a query so that I can get a result like this? kk kj pngk vote 01 02 c,b 15 Any help pretty much appreciated. -

[SQL] List table with same column name

Hi! How do I list all the tables in the database which has a same column name?. Thanks ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] Timestamp

Hi ! In my database I've a field "departure" with timestamp without time zone data type. eg : departure 2003-11-01 14:29:46 Now I want to select it as in this format 01-11-2003 14:29:46 How should I do it?. Thank you for any help. ---(end of broadcast)--

Re: [SQL] How to speeed up the query performance

Hai Chris! Thanks for the solution but seem it doesnt work. (0 rows) returned when I used NOT EXITS but (4 rows) returned when NOT IN is used... FYI I used 7.2 Christoph Haller wrote: How do I speed up the quey performance if I've a query like this : Does 'not in' comm

[SQL] How to speeed up the query performance

How do I speed up the quey performance if I've a query like this : Does 'not in' command will affected the performance?. select      ts.transportid,ts.transporttype,ts.transportcapacity,ts.transportstatus,ts.routecoverage,ts.transportregnumber from       transportsetup ts where     ts.bizid =

[SQL] select column from table

Hi everybody! I just want to know is there a way in SQL command that can handle column selection?. The case is : If I've a table with 10 columns and I want to select 8 of them without rewrite the columns/fields name in the SQL query? eg : Current SQL query is :- Select a,b,c,d,e,f,g,h from abcta

[SQL] How To Recover Deleted Data

I've accidentally deleted the data in my table. So How to recover it back. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[SQL] How to undelete deleted data

How can I undelete the deleted data from a table; ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] What this parser mean?

I wrote a java program to query a data from 4 tables and the string query is like: querydata ="select bizfavorite.bizid,bizprofile.bizname,bizprofile.bizphone,bizprofile.bizfax,bizfavorite.searchtype," + "bizfavorite.keyword,to_char(bizfavorite.listdate,'DD-MM-') as listdate,bizfavorite.offe

[SQL] USING INDEX

How do we determine which column/s to be set when creating an INDEX? As I understand, using INDEX the query will be more faster then without using INDEX. How about using INDEX if query is a JOIN query, which involved 4 tables. ---(end of broadcast)-