Hi,

This is the query am using for my application.

Select Registrationno,location,gps_datetime,speed,ignition,analog2 from gpsdata_history where registrationno='ht 34 555' and gps_datetime between '' and ''

Here i have used registrationno as non unique and...

Ya this is what am looking for. Thanks a lot

Hearty thanks, i will test and revert you if i have any issues

once again thanks for your kind reply.

Actually sno is just an identity column. I am going to filter only by using registrationno and i will have many registrationno in this...

Index is getting used, i tested using the query execution plan.

Here do i provide the data structure,index and query.

1, data structure

USE [bulkdata]

GO

/****** Object: Table [dbo].[gpsdata_history1_April] ...

First of all, Thanks for your reply.

My table has lakhs of records. Client will access this data so often. THere is no writing process and only reading Hence i'm testing...