Thank you sir for reply.

Plz find attached query execution plan.

the database is in oracle.

Thanks.

Thank you sir. I want like this. Thank you very much.

Thank u very much..

Here I have attached actual execution plan

Thanks.

Hi Experts,

Following is the query as per my old view .

SELECT DISTINCT tbl_Visitor.VisitedDate, tbl_Visitor.Organization, tbl_Visitor.ISP, tbl_Visitor.LocationID, tbl_Visitor.CompanyName, tbl_Visitor.IPAddress,

...

Thank you very very much.

HI,

My sql query is still executing so that not able to get actual execution plan.

It was running from past 15 min. and able to fetch near about 600 rows only.

I changed data type to bigint

and applied unique index.

i have attached here new execution plan here.

Thanks

Thanks..

i am trying with all the changes that u have told me..

Will update you soon..

Is there any other way to join between these to tables as that joins incurs...

ya.. we can create unique index on StartIP and EndIP.

But this will not solve my problem.

I planned to save ID in organization table in CompanyVistedProfile table when visitor...

Thanks for reply.

And what about fetching records (Select Query) as I want the organization Name.

Is there any other way with that select query to get records in faster way (as...

Only Primary Key. No Indexes.

I am fetching all the rows using that above query.

IS any other wat to achieve my target the please tell me.

Thanks

CREATE TABLE [dbo].[IPLocationDB_Organization](

[ID] [bigint] IDENTITY(1,1) NOT NULL,

[startIP] [nvarchar](100) NULL,

[endIP] [nvarchar](100) NULL,

[organization] [nvarchar](4000) NULL,

CONSTRAINT [PK_IPLocationDB_Organization] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =...

HI,

I have to track the visitor details who visited to companies in my database. I am tracking their datails using there Ip address. I converts that IP into...

I have attached Query execution plan and some rows of tables..

Thanks