How did I made the longest explain plan with this SQL query?

[SorryButImaNewbie]

Hello, I would like to write a simple query, where I count new registrations monthly.

The monster I created can't be made as an explain plan in normal time borders. I suspect my logic is somewhere flawed, syntax I think is good (at least i didn't get syntax error).

my query:

SELECT
  EXTRACT(MONTH FROM  DATABASE.REGHISTORY.X__INSDATE),
  --TRUNC(X__INSDATE, 'MONTH') as HONAP
  COUNT(X__INSDATE)
FROM
  DATABASE.REGHISTORY
GROUP BY EXTRACT(MONTH FROM  DATABASE.REGHISTORY.X__INSDATE);

 I supposed I should try to count something else, but it didnt finsih neither when I tried to count IDs.

I would like my table in a format simply like: month/Summed registrations that month

EDIT: I also wanted to order by maybe in ascending order, but for now I try to make it so it gives back what I want first

EDIT2:  Oracle SQL developer 4.0.0.12 (sorry, I should have started with this..)

Thank you!

PS.: I hope this is the right thread to ask something like this, general help I thought is for autoit mostly.

Edited March 17, 2015 by SorryButImaNewbie

[jchd]

I use SQLite not Oracle and SQLite doesn't have the same date dissection functions, but when I try this I get the expected result:

select substr(x__insdate, -2) as Month, count() from reghistory group by month order by month;

Hence I suspect this would work as well for you:

SELECT
  EXTRACT(MONTH FROM  DATABASE.REGHISTORY.X__INSDATE) as Month,
  COUNT()
FROM
  DATABASE.REGHISTORY
GROUP BY Month order by Month;

Edited March 17, 2015 by jchd

[SorryButImaNewbie]

Thank you!

This gives me back ones and twos in both column, don't know why because the logic should be fine I may made it with the next code

select
trunc(x__insdate 'month') as month
count(*) -- Here I actually count x__insdate, shouldnt that be quicker then count everything?
from database.table
group by month order by month

Thank you for the input

Edit: -- as comment line doesn't seems to work for me

Edited March 18, 2015 by SorryButImaNewbie