S&P Global Interview Questions: Why we use views, can we create indexes on that?

Asked inS&P Global,Software Development Engineer II

Why we use views, can we create indexes on that?

AnswerBot

7mo

Views are virtual tables that simplify complex queries. Indexes can be created on views to improve performance.

Views are virtual tables created by querying one or more tables.
They simplify complex que...read more

Help your peers!

Add answer anonymously...

Top S&P Global Software Development Engineer II interview questions & answers

Q1. Difference between truncate and delete and when we prefer what operation?

View answers (2)

Q2. How to plan ETL for various data sources?

View answer (1)

Q3. Difference between clustered, unclustered, and unique index?

View answer (1)

S&P Global

Discover recent interview experiences

View all

Interview Tips & Stories

Ace your next interview with expert advice and inspiring stories

Explore community

Software Development Engineer II Interview process at S&P Global

based on 1 interviews

View all

Popular interview questions of Software Development Engineer II

Q1. Given 2 large numeric comma seperated strings. You need to calcul...read more

asked in

Zepto

View answer (1)

Q2. With HM 1. Projects 2. Major challenges during those projects 3. ...read more

asked in

Porter

Add answer

Q3. design a LLD of portfolio management system where you can add any...read more

asked in

Smallcase Technologies

S&P Global Interview Questions

S&P Global Software Development Engineer II Interview Questions

Stay ahead in your career. Get AmbitionBox app

Helping over 1 Crore job seekers every month in choosing their right fit company

65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

65 Lakh+

Reviews

4 Lakh+

Interviews

4 Crore+

Salaries

1 Crore+

Users/Month

Contribute

Contribute to help millions

Reviews

Users/Jobseekers

Employers

AmbitionBox Awards

AmbitionBox

Terms & Policies

Get AmbitionBox app