Fill factor is not really defined by the amount of data in the table but on the rate of data modifications.

To generate some tests, I did the following:

IF OBJECT_ID( 'STATE_COUNTY_CODES')...

Sean Lange (8/13/2015)

---

Luis Cazares (8/13/2015)

---

For Oracle, the first query should be something like this:

select *

from quer a

cross join (select 'Text1' as MyText FROM Dual union all select 'Text2' FROM Dual)...

I could give it a try.

Thank you all for the nice comments.

You're right Hassan, my code is wrong and that might be the reason for not getting the same results on the 2 approaches. I...

Sean Lange (8/13/2015)

---

jodevil99 (8/13/2015)

---

FROM keyword not found where expected

missing keyword

select *

from quer a

cross apply (values('Text1'), ('Text2')) x...

This is the issue, which doesn't represent a problem since it's a small table. Check Ron's comment.

Can you post the table and index creation code including the fill factor?

Are you using Oracle?

The DISTINCT keyword is redundant as you're using GROUP BY. You're also giving average which is the mean and not the median.

Grant Fritchey (8/13/2015)

---

Luis Cazares (8/13/2015)

---

Eirikur Eiriksson (8/13/2015)

---

Grant Fritchey (8/13/2015)

---

I'm sure that a large part of this is English as a second language. But lordy,...

That reminds me of a job posting I recently received on the mail. Even if...

Eirikur Eiriksson (8/13/2015)

---

Grant Fritchey (8/13/2015)

---

I'm sure that a large part of this is English as a second language. But lordy, can the questions be...

Just to expand on what Grant said, instead of having this:

IF EXISTS (

SELECT insuranceBilling.InsurerID

...

Beagle

jasona.work (8/13/2015)

---

GilaMonster (8/13/2015)

---

I'm working with one of those. Fortunately it's not case sensitive, but the...