Hi all, I am administratin an oracle database and I have the following
issue.
I have the following query:

Select
 field1
From
 table1
Where
 field2 is null
And field3 = <some value>
Group by
 field1;

Table1 has 808.000 records so it takes half a second or so to solve the
query. I was wondering if a index on table1 for the fields "field2" and
"field3" would speed this query.
What do you think? Is that correct? Are there other ways to speed this
query?

Best regards and thanks
Roberto.-


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting