Query Optimization

Calculating prior Query fields

Inside my query, is four listed fields; date, printer, and a Start and End meter for daily meter readings to keep track of printer impressions. I'm trying to receive a return value by subtracting a meter reading from the START field in a current row and the END meter in the previous row depending...

View is taking so much time for fetching data

i have created multilevel view (ie:- a view is inheritng data from multipe view) and its taking so much time while fetching the data. can i reduce time taking for fetching data.

Updating a field and counting unique field values from another fields all in the same query?

How can I structure the following query to allow me to count the number of unique entries in a field named "amount" and using the same query, update another field named "unique" Here is what I am doing: SQL = "select amount, count(amount) from tblmessagein group by amount having count(*) = 1" If...

Need help with this Oracle Query

BPC_APPLICATIONS_TRANSACTIONS (Table) Application_no,Transaction_no,Transaction_date Step_id Dept_code Decision 20090045 1 01/14/2009 10:07:17 1 001 0 20090045 2 01/14/2009 10:07:17 70 007 0 20090045 3 01/14/2009 10:08:57 1 001 0 20090045 4 01/14/2009...

Matching External lists to your Database?

Hello everyone, I work in a telco and manage the data in the company's CRM. I'm often given lists of company names by our alliance team, and asked to match the list against our database to see which companies already exist in the CRM and which don't. At the moment I can only accomplish this by...

To retrieve records from SQL Server database

Hello All, I have a requirement with sql server. Please find below the same. In database say we have a column named "Name" in a table. The records that are available in the table are say like Column_Name = Names Lean Metric Sequence Lean Operation Metric Lean Cleaning and so on.... Now,...

Need help with Oracle query

how to display the third highest salary from an employees table thanks in advance

Query performance and tuning

Hi, I wanted know as to what I can do to my query so that it improves in performance.RIght now it it taking 3-4 hrs because of the large no of records in the DB.If i remove the group by and order by clause for the same no of records it is fast but when it does sorting it hangs.But I need to do the...

Clustered and Non-clustered Index

Hi, I have one table having more than 3 millions rows with following columns: [SITE_ID] [USER_NAME] [PAGE_TYPE] [DOC_ID] [FROM_PAGE] [TO_PAGE] [ORG_NAME] [LOG_DATE_TIME] [SESSION_ID] [IP] [MACHINE_ID] I am using 8 different queries, all thru stored procedure, to fetch data. ...

Optimizing Query

Hi, I am having a table which is having around 170 Columns(Don't blame me but my Developer) and there are only 989 records in the table.I created all sorts of Indexes but still the query (Select * from Table) takes almost 2 mins to display 989 records.I need all the columns to be displayed.Is there...