For a better answer we would need to take a look at the actual execution plan. Can you capture and upload it?

Also, the table and index script would help a...

Can you give us a table definition script and some sample data?

Please read the article linked in my signature line and you will find out how to post both.

This should do the trick:

WITH MonthNumbers ([1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12])

AS (

SELECT 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11,...

Please, don't take offence. but... wait until you receive your books and start studying.

Things will be much clearer.

My bad, the parameter had to be passed in as boolean...

-- Disable data access

EXEC sp_serveroption @server = 'linked_server_name'

,@optname = 'data access' ...

... buy more disk?

No, seriously, what is your concern exactly?

You may take a look at Paul Randal's VLDB maintenance checklist to get started.

You could set up a job to disable data access and the enable it back.

-- Disable data access

EXEC sp_serveroption @server = 'linked_server_name'

,@optname =...

No way, AFAIK.

It should have been in Full recovery.

The view exists, but you don't have permissions.

Which user is connected to SQL*Plus?

SELECT USERNAME FROM V$SESSION WHERE AUDSID=userenv('sessionid');

Enterprise Manager (or DBConsole) is the web application that controls and administers the database.

If you created a database with DBCA, you probably created the DBConsole as well.

Try opening https://localhost:1158/em

If...

Resender (12/23/2010)

---

On my windows machine I got 4 gig's of RAM, the only reason I decommissioned it was because of it being to expensive to upgrade it for dual or...

Wow! I love gifts!

This one looks pretty cool. I love the idea of a "script wiki" and the possibility to add some scripts of mine.

I coded something amazingly similar to...

I see. However I have no clue of how the optimizer will decide to work with the new indexes, beacause...

You're probably right, Paul.

If you have enough RAM, I wuold suggest installing VirtualBox, some flavour of linux and play with Oracle on that machine.

Oracle-Base has great guides on how to install. For instance:

http://www.oracle-base.com/articles/11g/OracleDB11gR2InstallationOnFedora14.php