Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is Function based Index and which type of function we can use in Function base index.
can we use aggregate,NVL function in Function based Index..

Question Posted / dinesh


What is Function based Index and which type of function we can use in Function base index. can we u..

Answer / dinesh

Its not batter to modify where clause column with function(Performance issue). So we need to create function based index. Eg.
Create Index Fun_indx on EMP (UPPER(FIRST_NAME).
we can't create function based index on aggregate function.
but we can create NVL function as function.
also we can create function based index on user define function but function should be"DETERMINISTIC".
eg
create or replace function fun_index(a in number) Return
Number DETERMINISTIC IS
BEGIN
'''
,,,
END;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is integrity constraints?

5 Answers   Ramco, Satyam,

What is differance unique key and primary key.

7 Answers   EDS,

what is try_catch block in procedure

0 Answers  

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

0 Answers  

Does pl sql work in mysql?

0 Answers  

Can we call a function containing dml statements in a select query?

0 Answers  

what is pragma ?

1 Answers   Polaris,

Is stored procedure faster than query?

0 Answers  

How many types of functions are there in sql?

0 Answers  

Can we use join in subquery?

0 Answers  

What is restrict in sql?

0 Answers  

What is procedure explain with example?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories