I am creating an index on Emp table Empno column,if u using
this indexed column in ur SELECT stmt. where clause,then how
do u know that yr index will be working or nor?
Thanks Advance...
Answers were Sorted based on User's Feedback
Answer / satish
Do the explain plan.if it is not using ur created index
then use hints to use ur created index
Is This Answer Correct ? | 6 Yes | 0 No |
You execute your query like
explain plan for select sal from emp where empno='1224';
after that check this below one.
select * from table(dbms_xplan.display);
here u can find it'll be excuted by using index or TABLE ACCESS FULL
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / manoranjan sethy
by using SET AUTOTRACE ON EXPLAIN tool you can came to know weather such index is working or not.
Is This Answer Correct ? | 1 Yes | 0 No |
have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.
Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...
Explain scalar functions in sql?
What is cost in sql execution plan?
What is the purpose of design view?
hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification
what are the different type of normalization? : Sql dba
Main diff between varray and nested tablea
what is the command used to fetch first 5 characters of the string? : Sql dba
What does pl sql stand for?
What does varchar include?
What is acid property in a database?