HowardW (5/15/2014)

---

bas_vdl (5/15/2014)

---

HowardW (5/15/2014)

---

bas_vdl (5/15/2014)

---

Hi HowardW,

Thanks for your input. You're right about the fact that the ip ranges are not overlapping. The query you suggest is very slow. In my...

HowardW (5/15/2014)

---

bas_vdl (5/15/2014)

---

Hi HowardW,

Thanks for your input. You're right about the fact that the ip ranges are not overlapping. The query you suggest is very slow. In my first post...

HowardW (5/15/2014)

---

As others have said, you can't avoid a scan if you're returning all rows, however, the naming of your tables does suggest there may be a better way.

1) IP...

Btw, the time indications I refered to is the time MS SQL Management Studio shows me (bottom right). I'm aware of the fact that displaying all those results in the...

ChrisM@Work (5/15/2014)

---

bas_vdl (5/15/2014)

---

Thanks for the quick reply. Your query is slightly quicker, it takes between 15 and 20 seconds on my dataset...

Are there any other query construction to lookup the...

spaghettidba (5/15/2014)

---

You cannot avoid the scan: you're asking for the whole SECURITY_EVENTS_STG_TEST table (no filter predicates).

As far as the index spool is concerned, I have no idea what it's trying...

Thanks for the quick reply. Your query is slightly quicker, it takes between 15 and 20 seconds on my dataset...

Are there any other query construction to lookup the country for...

CREATE TABLE [dbo].[IP2COUNTRY_LOOKUP](

[START] [bigint] NOT NULL,

[END] [bigint] NOT NULL,

[COUNTRY_CODE_ALPHA2] [varchar](2) NULL,

CONSTRAINT [PK_IP2COUNTRY_LOOKUP] PRIMARY KEY NONCLUSTERED

(

[START] ASC,

[END] ASC

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